Works for me...

Sub aa()
Dim x As ComboBox
Set x = UserForm1.ComboBox1
MsgBox x.RowSource
End Sub


--
Jim
"Ronald Dodge" wrote in message
...
| Windows XP, SP2
| Excel 2002, SP3
|
| Trying to create a variable to replicate the combobox within the userform,
| but needs to have the same setup of properties as shown within the
userform
| itself.
|
| MSForms.ComboBox has some of the properties of the actual combobox, but is
| missing certain fields such as the "RowSource" property
|
| MSForms.Control has some of the properties of the actual combobox, but is
| missing certain properties such as the "BackColor" property
|
| I don't like the idea of using the "Variant" or "Object" variable types
for
| when declaring the variable for this combobox representation. I would
| rather avoid code type problems such as code declaring as the wrong type
of
| variable when in Run-Time mode.
|
| I attempted at using the "Object Browser" to find what I was looking for,
| but only confirms that I'm missing certain things and doesn't seem to be
one
| specific object type available to list all of the properties of the actual
| combobox in use on the userform.
|
| For now, I am using the Control one as the RowSource property must be
used,
| but like to also be able to have all properties included via the variable
| object. From good programming practices, there shouldn't be 2 different
| variables representing the same object to handle different things within
the
| same procedure.
|
| Yes, this is using early binding so as Intellisense can kick into play
among
| other reasons.
|
| --
|
| Sincerely,
|
| Ronald R. Dodge, Jr.
| Master MOUS 2000
|
|