Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I refer to, for instance, ComboBox9 to ComboBox20?
I've tried the following but OLEObjects doesn't seem to work , but if I try to retrieve the object's name, no problem. I have a feeling the OLEObjects bit is read-only, but I'm not sure how to work round it, without naming each box. Dim iX As Integer, sBoxName As String For iX = 9To 20 sBoxName = "ComboBox" & CStr(iX) Me.OLEObjects(sBoxName) = "" Next The code is located in a Worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referring to cells on a different worksheet | Excel Discussion (Misc queries) | |||
formula referring to a worksheet | Excel Worksheet Functions | |||
referring a worksheet | Excel Worksheet Functions | |||
referring to other worksheet | Excel Worksheet Functions | |||
checking for errors in combobox's | Excel Programming |