where did you get the combo box from??

Control ToolBox
or
Forms ToolBox

Make a list in your worksheet
Name the list by highliting it and then goto=insert=name=define
put a one word name in the name box
if you used the combo box from the controll toolbox then..
right click on the combobox select properties, find rowsource and enter
the named range, now your box is populated,

Combobox from the forms toolbar,
rightclick on the combo box
select format control
select the control tab
input range, enter the range name or you can just click on the squarde
button and go to the range and highlite it and click ok

If you are using a combo Box for a UserForm you can populate it the
same way as the first explaination,
select the combobox on the userform, be sure it says combobox on the
properties window, go down to row source and enter the name of the
range


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521674