I'm writing a VBA code in Excel 2007... using a check box to trigger a Validation list, i need the user to select a value from it... but when the list is activated, it comes with no value on it so if the user simply ignores it, it allows to leave the cell blank...
i need to force the user to select a value before he or she does anything else..
any help will be appreciated...
Jorge
Whatever the next step is, or next few steps (cells), you can apply Data Validation to those cells that will not allow any editing at all unless the prior cell has a value other than blank.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks