lukeshuttlewood
Board Regular
- Joined
- Jul 27, 2004
- Messages
- 90
Hi
Is it possible, using VBA code to get the (name) of every control on the current user form then deliver that name to a cell on a spreadsheet.
The prgramme would be something like:
* Look at the first control in the userform (If there is some sort of order tag?)
* Get its name
* Put the name in a cell on a spreadsheet
* Look at the next control
* etc etc
Does anyone know any code that can cycle through controls in this manner?
Cheers
Luke
Is it possible, using VBA code to get the (name) of every control on the current user form then deliver that name to a cell on a spreadsheet.
The prgramme would be something like:
* Look at the first control in the userform (If there is some sort of order tag?)
* Get its name
* Put the name in a cell on a spreadsheet
* Look at the next control
* etc etc
Does anyone know any code that can cycle through controls in this manner?
Cheers
Luke