Hi There,
I have a dropdown list that contains 250 names, I want a way to have a pop-up message when I select 3 specific names, but not to appear when I select any of the other names.
Any help greatfully appreciated
Regards
Paul
Hi Paul
I assume your list is selected via Data Validation.
I have 3 suggestions:
1) Just use an IF combine with a MATCH (or VLOOKUP) next to the selection to display a message in the cell.
2) Use Conditional Formatting to change the color of the cell (no message).
3) Use an Worksheet Event macro (pop-up message).
Whichever way you use, you will need a list of the 3 names for the checking.
Hope this helps.
Sunny
Can´t download or view the attached file to see your solution Sunny. Maybe a fault on the Forum, but can you try also and/or place it again?
Thanks!
Frans
Hr Frans
Please refer attachment.
Sunny
Yes, this one was downloadable. Works nice and fine Sunny. Hope this is what Paul was looking for.
Frans
Thanks Sunny