Change event macro - Select cell

[shsassy]

Hello all,

I've got a question about some VBA programming. What I would like to do is when a user clicks on a certain cell on one of my worksheets I would like a message box to pop up.

First off I am not sure which event handler to put the code as none of them seem really suitable.

Then the code I am also not sure of. I've tried something like:

Please Login or Register  to view this content.

That doesn't seem to work. I also have already used the built in data validation on the cell so I can't do it that way either.

Can anyone help me?

Thank you all!

[VBA Noob]

Right click the summary sheet > select view code and paste in the below

Please Login or Register  to view this content.

VBA Noob

[shsassy]

Thanks for the reply but that does not seem to work.

Do you think it could be because cell F15 is actually merged with G15? usually I just reference it with F15 and it works like that but I did try "F$15:G$15" didnt work either. Any other ideas?

[shsassy]

Actually, no, it can't be because of the merged cell as I tried it in one that was not merged and it doesn't work.

[VBA Noob]

Yes it's the merge.

Try

Please Login or Register  to view this content.

VBA Noob

[shsassy]

Ok great, at first that wasn't working for me but I saved it, closed the workbook and opened it and it started working.

Thanks so much for your help Mr. Noob :P

[VBA Noob]

Glad it helped

VBA Noob

[Paul]

I tried VBA's code on a non-merged cell and it worked just fine. I then tried his updated code on a merged cell and it worked, too.

Remember, this isn't a CLICK event code, it's a SELECTION CHANGE event code. Cells don't have a CLICK event. If cell F15 were selected, and you click on it again it will not trigger the macro. But if any other cell were selected and you either clicked on F15 or used arrow keys to move to that cell the macro will trigger because the SELECTION is CHANGING.

[VBA Noob]

Some link if your interested

http://www.mvps.org/dmcritchie/excel/event.htm

http://www.cpearson.com/excel/Events.aspx

VBA Noob