I currenly have a macro that runs and ends with an input box popping u
asking the user to enter yes or no. It goes as follows:

Range("N53").Value = InputBox("Yes or No")

However, as this is an input box the text is a free field and the ye
or no is just a title. To avoid errors on input (ie people pressing
for yes) i want this input box to be a drop down box, or i only wan
the user to be able to select the options i offer.

Any though

--
chalk
-----------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...fo&userid=2375
View this thread: http://www.excelforum.com/showthread.php?threadid=50110