Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accesing a combobox control via it index propertie in VBA, Is itPossible?
I have a series of Comboboxes on a form I want to use w/ a workbook.
I notice that the Index Property is not there. How is this done in VBA? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accesing a combobox control via it index propertie in VBA, Isit Possible?
ijb wrote:
Are you talking about the tabindex? Sub ijb3() Dim MyCtrl As Control For Each MyCtrl In UserForm1.Controls MsgBox MyCtrl.Name MsgBox MyCtrl.TabIndex Next End Sub No I am talking about the Index Property that is included in VB6. For example if I were to make a control array in VB6 I would use their idex to handle them. I do not see How I could either array comboboxes or use the Index Property in VBA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accesing a combobox control via it index propertie in VBA, Isit Possible?
That is true, there are no control arrays in VBA.
Regards, Tom Ogilvy Muxer wrote in message news:6GEVa.13729$uu5.1523@sccrnsc04... ijb wrote: Are you talking about the tabindex? Sub ijb3() Dim MyCtrl As Control For Each MyCtrl In UserForm1.Controls MsgBox MyCtrl.Name MsgBox MyCtrl.TabIndex Next End Sub No I am talking about the Index Property that is included in VB6. For example if I were to make a control array in VB6 I would use their idex to handle them. I do not see How I could either array comboboxes or use the Index Property in VBA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accesing a combobox control via it index propertie in VBA, IsitPossible?
Tom Ogilvy wrote:
That is true, there are no control arrays in VBA. Regards, Tom Ogilvy Muxer wrote in message news:6GEVa.13729$uu5.1523@sccrnsc04... ijb wrote: Are you talking about the tabindex? Sub ijb3() Dim MyCtrl As Control For Each MyCtrl In UserForm1.Controls MsgBox MyCtrl.Name MsgBox MyCtrl.TabIndex Next End Sub No I am talking about the Index Property that is included in VB6. For example if I were to make a control array in VB6 I would use their idex to handle them. I do not see How I could either array comboboxes or use the Index Property in VBA Anyone know a way to siulate this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form control combobox | Excel Discussion (Misc queries) | |||
Control ToolBox ComboBox | Excel Discussion (Misc queries) | |||
Combobox control problems in a grouped cell | Excel Programming | |||
Assigning Multiple Macros to One ComboBox Control | Excel Programming | |||
Assigning Multiple Macros to One ComboBox Control | Excel Programming |