Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation list: how do i 'force' a user to enter data from the list?
....what i mean is, how do i prevent a user from just leaving the cell
empty. i have a list of countries in column A, and in column B i have created a data validation list (of prices). but users can simply leave column B empty if they wish to - how do i force them to 'pick' from the list? hope this makes sense. thanks column a column b (drop down list to choose from) belgium denmark uk etc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation list: how do i 'force' a user to enter data fromthe list?
Data validation checks the entries that are made in a cell. It can't
prevent users from leaving a cell empty. Perhaps you change other formulas on the worksheet, so they don't return a result if the price cells are empty. showsomeidnow wrote: ...what i mean is, how do i prevent a user from just leaving the cell empty. i have a list of countries in column A, and in column B i have created a data validation list (of prices). but users can simply leave column B empty if they wish to - how do i force them to 'pick' from the list? hope this makes sense. thanks column a column b (drop down list to choose from) belgium denmark uk etc -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation list: how do i 'force' a user to enter data from the list?
Without some VBA event code that runs before save or close it is impossible to
"force" a user to enter something in a cell if they choose not to. And then you must rely on macros being enabled when user opens the workbook. And a contingency plan in the event they disable macros. You could just also use Condtional Formatting to color the cells that need filling. When filled the color would disappear. Nothing foolproof, just a reminder to users. Gord Dibben MS Excel MVP On 29 Apr 2007 14:50:11 -0700, showsomeidnow wrote: ...what i mean is, how do i prevent a user from just leaving the cell empty. i have a list of countries in column A, and in column B i have created a data validation list (of prices). but users can simply leave column B empty if they wish to - how do i force them to 'pick' from the list? hope this makes sense. thanks column a column b (drop down list to choose from) belgium denmark uk etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force user to enter data in cell before moving to next cell | New Users to Excel | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
Refresh existing data when changed in data validation list | New Users to Excel | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |