Worksheet_Change Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning all!

I have read several posts about the Worksheet_Change Event and I need to
adapt this into my code. However, I hate to put code in that I don't
understand and for some reason I am having a difficult time figuring out how
this works. Can anyone give me a quick rundown on how to use this code?!?!

Thank you!!!
 
Anytime a change is made to the worksheets, whatever code you have will run.
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "hi"

End Sub

this for example will show you what is happening, put it in and commence to
typing in the cells.
 
To see a little more of the capabilities pop these in there and give it a look
MsgBox Target
MsgBox Target.Address

Those give you an idea of what you can do, see what someone typed and/or
where they typed it. you can monitor changes or use an offset to put a
timestamp etc.
 
Thanks John and Gary, I figured it out after I made the post! I just didn't
give my little brain enough time to let the squirle get the wheel going fast
enough! :)

Anyway, Thanks agian for your help!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass value variable to worksheet event 3
Can Worksheet_Change call itself? 6
Excel events appearing unexpectedly 4
Fire Worksheet_change event from module 3
Worksheet_Change event not triggered as expected 4
Worksheet_Change() and range question 8
Worksheet_Change event 3
Force Worksheet_Change event 1

Back
Top