Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Commandbutton captions
I have a Userform that is initiated by user selection of certain cells, and I
need to display a number of CommandButtons corresponding to the length of a list associated with the user selection. My form has the maximum number of buttons I ever expect, and a macro sizes it to display only those needed. Im looking for a simple loop to add captions from the list, but I dont see any way to index the button reference in a loop. What Im trying to do: For n = 1 to List Count CommandButtonn.Caption = Range(€śList€ť).Offset( n, 0) Next Obviously that wont work, so I seem to be headed for a brute force method. Is there a more elegant way? -- Al C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis captions | Charts and Charting in Excel | |||
label captions | Excel Programming | |||
Labels and Captions | Excel Programming | |||
How do I put captions on Excel charts? | Charts and Charting in Excel | |||
Userform Captions | Excel Programming |