In the data validation, I have selected a list, identified the source rang that refer to a list of 6 options.
I want an information message appear if the user selected option # 3 only.
Also, I want to know any command that can create a message in xls (without using data validation).
I would appreciate any help. Thank you.
instead of Data validation list select Data validation >custom and give the formula
Assume you are in cell A1
=NOT((A1="XYZ"))
this will get the message when user enter XYZ in A1
Can create a message without data validation too,
Hi Buddy You'll have to use VBA to create this kind of action.
So i'd suggest another tact if you are not familiar with this? perhaps putting a formula in the next cell along:
Where A1 is the cell that drops down.
Please Login or Register to view this content.
As for the message box its VBA so again if you're not familiar start raeding, i'd recommend contextures.com its pretty solid.
the command anyway is:
Hope that helpsPlease Login or Register to view this content.
Mr MaGoo
Magoo.Inc MMVII
If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks