View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Muxer Muxer is offline
external usenet poster
 
Posts: 5
Default 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