View Single Post
 
Old 10-19-2023, 08:40 AM
MC147 MC147 is offline Windows 10 Office 2021
Advanced Beginner
 
Join Date: Feb 2022
Posts: 50
MC147 is on a distinguished road
Default Copy the Code from an Excel Form to a Worksheet automatically

Is there a way to automatically copy the userform VBA code to a worksheet. Obviously I can do this by manual copy and paste, but I want to do it at the click of a button for all my userforms. If I could export just the code to a file, that would also work as I could manipulate it later.
Haven't found anything on the internet and all my searches just get directed to people working with Worksheets not User Forms.
Ideally, I want to write some VBA code that will loop through all User Forms in my Excel file, copy the code to a worksheet - with the name of the User Form, and then I'll do some manipulation and extraction of the data I'm interested in.
Reply With Quote