Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Drop Down Box
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro with Drop Down Box | Excel Discussion (Misc queries) | |||
Drop down list macro? | Excel Discussion (Misc queries) | |||
Macro to add drop-down lists | Excel Discussion (Misc queries) | |||
Drop Down Box & Macro | Excel Discussion (Misc queries) | |||
Macro that changes Drop Down Box | Excel Programming |