|
|
|
|
#1
04-09-2012, 05:14 AM
|
||||
|
||||
Hi shira47,
To do that, you'd need an automatic macro that fires whenever B1 or B2 is updated and either populates C1 with N/A or adds a data validation control to that cell for date entry - then selects C1.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Data validation using indirect function
|
BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
| Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |
|
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
| Outlook userform validation help | aiwnjoo | Outlook | 0 | 12-08-2010 12:57 AM |
| Trouble With Data Validation And Filtering On A Dropdown | zura04 | Excel | 0 | 10-24-2006 12:54 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode