Why not use a MsgBox

If MsgBox("Select Yes or No", vbYesNo) = vbYes Then
Range("N53").Value = "Yes"
Else
Range("N53").Value = "No"
End If

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chalky" wrote in
message ...

I currenly have a macro that runs and ends with an input box popping up
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 yes
or no is just a title. To avoid errors on input (ie people pressing Y
for yes) i want this input box to be a drop down box, or i only want
the user to be able to select the options i offer.

Any thoughs


--
chalky
------------------------------------------------------------------------
chalky's Profile:
http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=501107