Use ADO to query SQL2000, and populate an array with the recordset, and then
load the combo from that array.

As to whether activex or userform, it depends what else you want. If it is
only a combobox, activex should be enough, if you want more controls related
to the combo, you would probably be better with a userform.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mandy" wrote in message
...
Please can someone tell me how to populate a combo box from a SQL query
against SQL2000?
I'm using XL2000 and W2K. And should I be using activex or userform
controls - is there a difference?
Thanks for any help