George,

You may not need to write code. In Design Mode (button on the Control
Toolbox), right-click the combo box, Properties. In the properties windows
that opens, set ListFillRange to a range on your sheet.
--
Earl Kiosterus
www.smokeylake.com

"twinklejmj" wrote
in message ...

Hi,
I urgently need to write a macro (with auto_open) to populate the combo
box (and activate it) that I created in a work sheet using the icon in
the control tool box. Could any of you help please?

Thanks.

George


--
twinklejmj
------------------------------------------------------------------------
twinklejmj's Profile:
http://www.excelforum.com/member.php...o&userid=27085
View this thread: http://www.excelforum.com/showthread...hreadid=466121