Is it possible to get the (Name) of every control on a form?

[lukeshuttlewood]

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

 

[Von Pookie]

This seems to work for me:

Sub test()
Dim ctl As Control, i As Long

i = 1
For Each ctl In UserForm1.Controls
    Cells(i, 1).Value = ctl.Name
    i = i + 1
Next ctl

End Sub