If for the control toolbox toolbar, change the Style Property to
fmStyleDropDownList

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
I have a combo box which refers to a list within my excel, when the
combo box appears the user is still capable of typing in this box, can
i stop this thus making the user only select from the dropdown list,
thanks

johny5