I'm new to VBA. I'm trying to make an object pointer so I can
dynamically populate some ComboBoxes. Here is what doesn't work:
Code:
--------------------
Public Sub showForm()
UserForm1.Show
Sheet1.Activate
For i = 1 To 4
a = "UserForm1.ComboBox" & i
a.ColumnCount = 1
a.RowSource = "A2:A11"
Next i
End Sub
--------------------
I've tryed switching data types with "as object" with no luck.
Searching for this on the web is crazy. It seems everyone wants some
pointers on using excel. :)
--
rando4
------------------------------------------------------------------------
rando4's Profile:
http://www.excelforum.com/member.php...o&userid=28315
View this thread:
http://www.excelforum.com/showthread...hreadid=478994