Message box to pop up if a particular value is entered

[Neil Goldwasser]

It works! It works! It works!
Thanks ever so much for that Norman, you've made my day! I was even brave
enough to try adding a fourth group and corresponding message to see if I was
able to add subsequent groups, and to my surprise I could! Just goes to show
what you can do when you have somebody much cleverer to do it for you!!

I owe you one, this will really help our new tracking system! (in case I
haven't already mentioned the overall aim of my project is to design a brand
new tracking form to effectively monitor the support provided to the students
we have at the college with learning difficulties. It will now mean that
students won't "slip through the net" and miss out on the support that they
are entitled to. So you have been helping a good cause and I really
appreciate it!)

Thanks for the warning about spammers by the way, I'll bear that in mind.

Okay, I think case closed on that matter now. Thanks to everyone, Neil
Goldwasser

 

[Robb27]

Hi Neil,

I put the code in the module behind Sheet1; I selected Sheet2 and defined
the name ModificationRights to refer to cells A1:A10 (Insert | Name |
Define ...); I populated the newly named range on Sheet2 with some first
name (Anne, Ben, Carol...).
Returning to Sheet1, entering any of the names from the Sheet2 named range
caused a "Your Group Message!" msgbox to appear.

Assuming that the name is a workbook level name, it should not matter where
the named range is within the workbook.

Can you change this to happen when any cell is selected instead of typing
admin or anything else into a cell?