Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programatically reference controls on spreadsheet
i am trying to loop through all the controls on a spreadsheet and set certain
properites. In a userform, i am able to accomplish this with the following code ~ for each control ~userform.controls("button"&i).caption="asdf" however, i am at a lose as to how to loop through the controls placed directly on a worksheet as opposed to the userform. any help would be appreciated thks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatically access Excel 2003 spreadsheet | Excel Programming | |||
Adding a reference programatically | Excel Programming | |||
how to access programatically added controls | Excel Programming | |||
Programatically saving XML file as Excel spreadsheet | Excel Programming | |||
Programatically adding worksheets to a spreadsheet | Excel Programming |