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

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

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