Dave Peterson Wrote:
You can do it if you used the combobox from the control toolbox
toolbar.

What did you use to create the dropdown boxes?


HI Dave,

I used data validation to create the drop dow lists. Not too sure on
how to use comboboxes to perform this function to be honest!!!

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=550796