Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple drop down -data validation no freehand text
Hi
A little while ago I posted a question on how to get a multiple option dropdown using the data validation option (unfortunately I can't seem to find the thread). The solution suggested worked great. The user selects an option in the dropdown at the top of the spreadsheet which then altered the options available in the rest of spreadsheet. Example Select Option A at the top and only 1,2 and 3 are available in the dropdown. Select Option B and only 4,5 and 6 are available. It used the following code in the data validation: =OFFSET(ActivityStart,MATCH($B$3,ActivityColumn,0)-1,1,COUNTIF(ActivityColumn,$B$3),1) However it has one problem, unlike a normal data validation the user can type over the options provided with their own selection. I want to lock it down with just my choices. Is this possible? Any suggestions greatly appreciated Rexmann (using excel 2007) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple drop down -data validation no freehand text
Excel 2007 Data Validation
Dependent drop-down. With type-over error flag. With Advanced Filter and event macro. http://c0444202.cdn.cloudfiles.racks.../12_14_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I chg the text size in my validation drop down box? | Excel Worksheet Functions | |||
Text in Data Validation drop down box too small. Is there any thi | Excel Worksheet Functions | |||
Data Validation drop down for multiple worksheets | Excel Worksheet Functions | |||
Text size in validation drop-down list box | Excel Worksheet Functions | |||
data validation list drop down text format too small | Excel Worksheet Functions |