While in design mode (another icon on that control toolbox toolbar), you can
right click on the combobox and choose properties.

Look for linkedcell, listfillrange and matchentry.

and change style to fmstyledropdownlist--if you only want the user selecting
from the list (no typing allowed).



Siobhank wrote:

Gotcha.

Ok, once I have a combobox from the control toolbar, how do I enter my
list values? How do I set matchentry?

--
Siobhank
------------------------------------------------------------------------
Siobhank's Profile: http://www.excelforum.com/member.php...o&userid=26133
View this thread: http://www.excelforum.com/showthread...hreadid=394611

--

Dave Peterson