Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Test if moving off a cell without choosing a value

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
choosing a cell from a range Robert-Alpha[_2_] Excel Discussion (Misc queries) 1 September 12th 07 10:37 PM
choosing the a cell from a range Robert-Alpha[_2_] Excel Discussion (Misc queries) 3 September 12th 07 09:16 PM
Excel formula(?) for choosing only 1 cell.. cjtj4700 Excel Discussion (Misc queries) 1 November 24th 05 10:36 AM
choosing a cell with a comment kate nz Excel Discussion (Misc queries) 4 November 8th 05 10:35 AM
Choosing from 2 formulas for one cell rechan Excel Programming 1 May 21st 05 06:18 AM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"