| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refering to an object with a variable
I have a userform with a number of Command Buttons (Button1, Button2,
etc...). Before the form loads, I would like to change the caption of each of the buttons (with the use of a loop) to the contents of certain cells. Can anyone help me with the syntax is to do so. For example: For x = 1 to 20 ProjectForm.("Button" & x).Caption = Sheet1.Cells(2, x + 2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| refering to worksheet cell under shaoe object | Excel Programming | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
| refering to a range with a variable | Excel Programming | |||
| Simple problem refering to variable in For ... Next loop ... | Excel Programming | |||
Threaded Mode
