combobox control how to's?
 

Hi,

Using Excel 2003 and I'm making a form. On this form I have a combobox
control that I would like to populate from a call made to a remote database,
SQL 2000. The only way I can see how to do this so far is to retrieve the
list to an Excel range of cells. My problem is that the number of items
returned in the list will vary from time to time, how can I accomodate this?
I would also rather not have another worksheet open just for garbage like
this if possible, doesn't seem very clean.

For now I'm populating the list manually using additem, which is working Ok.
But when I run the form the control is initially blank, how can I set a
default value? I'm more used to Visual FoxPro and the combobox control they
provide has a 'FirstElement' property I use for this purpose but I don't see
that property here. Oh, I do have the style set to 2 - fmStyleDropDownList.

Thanks in advance,
Linn

combobox control how to's?
 

http://tinyurl.com/rt8z4

--
Regards,
Tom Ogilvy


"Linn Kubler" wrote:

Hi,

Using Excel 2003 and I'm making a form. On this form I have a combobox
control that I would like to populate from a call made to a remote database,
SQL 2000. The only way I can see how to do this so far is to retrieve the
list to an Excel range of cells. My problem is that the number of items
returned in the list will vary from time to time, how can I accomodate this?
I would also rather not have another worksheet open just for garbage like
this if possible, doesn't seem very clean.

For now I'm populating the list manually using additem, which is working Ok.
But when I run the form the control is initially blank, how can I set a
default value? I'm more used to Visual FoxPro and the combobox control they
provide has a 'FirstElement' property I use for this purpose but I don't see
that property here. Oh, I do have the style set to 2 - fmStyleDropDownList.

Thanks in advance,
Linn