ComboBoxes in VBA

[Ronald Dodge]

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

 

[Jim Rech]

Works for me...

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


--
Jim
| 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
|
|

 

[Dave Peterson]

I built a userform with a combobox and a commandbutton. This was the code
behind the userform:

Option Explicit
Private Sub CommandButton1_Click()
Dim CBX As MSForms.ComboBox
Set CBX = Me.ComboBox1
MsgBox CBX.RowSource
End Sub
Private Sub UserForm_Initialize()
Me.ComboBox1.RowSource _
= Worksheets("sheet1").Range("a1:a10").Address(external:=True)
End Sub

It seemed to work ok for me.

 

[Ronald Dodge]

Why then does this not show up in the Intellisense or within the Object
Browser?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

 

[Dave Peterson]

I don't know.

Why then does this not show up in the Intellisense or within the Object
Browser?

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000