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