| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning the name of a userform/control to a changing string
I want to attach a name to a userform (i.e. userform1,2,3 etc) or a control
within a form (i.e. TextBox1,2,3 etc) by means of a loop. How do I name the userform/control with a variable such as a string ... Dim UF as UserForm Dim str as string Dim j as Integer For j = 1 to 5 str = ³UserForm² & j UF.Name = str UF.Show Next j - It doesn¹t work, but is it close? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a single word match in a text string and assigning a code | Excel Worksheet Functions | |||
| Enter date in userform using Calendar Control | Excel Discussion (Misc queries) | |||
| Passing variable values to userform control | Excel Discussion (Misc queries) | |||
| control toolbox and userform toolbars in XL 03 | Excel Discussion (Misc queries) | |||
| Combo Box Control keeps changing sizes | Excel Worksheet Functions | |||
Threaded Mode
