![]() |
#1
|
|||
|
|||
![]()
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. |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kiwimtnbkr | Excel Programming | 23 | 10-08-2020 02:32 AM |
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA | ganesang | Excel Programming | 1 | 03-26-2020 06:18 AM |
How to get Excel to automatically continue a pattern which is form as 001-01-01 ....003-03-03 | anakonda93 | Excel | 3 | 04-16-2018 12:01 AM |
Automatically copy/paste a form field onto new pages, with user input included | Pindar | Word VBA | 3 | 01-13-2017 11:49 AM |
![]() |
shakilhyd | Excel | 2 | 05-17-2010 07:50 AM |