vba - Create Message box, when cell is selected (excel) -

vba - Create Message box, when cell is selected (excel) -

private sub worksheet_change(byval target range) if target.address = "$b$1" msgbox "something" end if end sub

hello, have problem macro, want create pop-up message when clicks on b1. macro reason does'nt anything, it's simple/stupid, has idea's?

you're using wrong worksheet event. need utilize worksheet_selectionchange event so:

private sub worksheet_selectionchange(byval target range) if target.address = "$b$1" msgbox "something" end if end sub

make sure place in sheets module wish fire from.

excel vba