Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic range and data validation
Hi, I have list range where I put data validation to prevent users from
entering wrong options. Then I put a drop-down list that is populated from a dynamic range of a list of valid options in another worksheet (same workbook) and set up the data validation to show an error message if an user tries to enter a non-valid option. The thing is... it is not working. The drop down list works fine, but I still can enter any value and recieve no message. What am I not considering here??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic range and data validation
Highlight the cells.
Select Data, Validation. The "Error Alert" tab is where you can insist an entry is only allowed from the list as an Error, Warning or for Information only. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic range and data validation
If there's a blank cell in the range you'll be able to type any value in
the cell with data validation. If that's the problem, remove the blank cells from the range, or on the Settings tab in the Data Validation dialog box, remove the check mark from Ignore blank. GSB wrote: Hi, I have list range where I put data validation to prevent users from entering wrong options. Then I put a drop-down list that is populated from a dynamic range of a list of valid options in another worksheet (same workbook) and set up the data validation to show an error message if an user tries to enter a non-valid option. The thing is... it is not working. The drop down list works fine, but I still can enter any value and recieve no message. What am I not considering here??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamic range and data validation
Well, I thought that checking the Ignore Blank option meant: YES IGNORE
BLANKS, which is what i want to do... but as you suggested, I un-checked it and it is working just fine... thanks!!! "Debra Dalgleish" wrote: If there's a blank cell in the range you'll be able to type any value in the cell with data validation. If that's the problem, remove the blank cells from the range, or on the Settings tab in the Data Validation dialog box, remove the check mark from Ignore blank. GSB wrote: Hi, I have list range where I put data validation to prevent users from entering wrong options. Then I put a drop-down list that is populated from a dynamic range of a list of valid options in another worksheet (same workbook) and set up the data validation to show an error message if an user tries to enter a non-valid option. The thing is... it is not working. The drop down list works fine, but I still can enter any value and recieve no message. What am I not considering here??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Data Validation | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions |