Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i've a problem in VBE (visual basic excel).
i've created a user form with more than 30 command buttons. for each command button i've to change its field ".caption" capturing a specific cell content. for example: in cells A1:A30 i've 30 different names. i've to associate : range("A1").value to commandbutton1.caption ...... ..... range("A30").value to commandbutton30.caption i would like to do it with a cycle (for..next, or smthg similar). the code i would like to writew down is: for every commandbutton in userform1 do commandbutton.caption=range("A1").value the problem is i've to specify the number of command button i'm workin' with so the extended code i actually use is : with userform1 commandbutton1.caption=range("A1").value ...... commandbutton30.caption=range("A30").value i would like to substitute these 30 lines of code with a single cycle/loop. thanks in advance . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you change seconds to cycles? | Excel Worksheet Functions | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Excell freezez after many macro cycles. | Excel Discussion (Misc queries) | |||
command buttons | Excel Worksheet Functions | |||
Control Buttons vs. Command Buttons | Excel Programming |