Hi, Happy new year2008
my case can do by any way...
my excel file sheetname "sale" . when user key the value or text in cell E5,A6,A7 but cell E46 and F46 have no value . let it show the msg. " your select or key wrong "
IF USER KEY OR SELECT IN CELL E5,A6,A7 AND CELL E46,F46 SHOW VALUE NOT SHOW ANY MSG.
You can use cell validation for this.
Select cell E5 and set Cell Validation to Custom with the Formula
=AND(NOT(ISBLANK($E$46)),NOT(ISBLANK($F$46)))
the Ignore Blanks check-box should be un-Checked.
The message to be displayed can be controlled by one of the tabs.
Copy / PasteSpecial Validation can move this to A6 & A7.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank,
I Can Not Do It E5 Now Is For Selected With The Validation List
So I Can Not Put Your Code In
How Can Another Code, As The Vba Code To Show Pop Up With The Msg Box.
Last edited by VBA Noob; 12-30-2007 at 05:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks