Test if moving off a cell without choosing a value

T

Tom Melosi

Is it possible to test whether a value has been entered in a cell before they
move from that cell?

The user will pick a code from a list in column B. I have a
Worksheet_Change event that populates a data creates a validation list in
column D based on the code the user picks. The event then selects the cell
the data validation was created for (same row, but in column D).

Is there a way to make sure the user enters or picks a value fromt the data
validation list?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top