Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event
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!!! -- I am not where I intended to go, but I think I am where I am supposed to be! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event
See:
http://www.cpearson.com/excel/Events.aspx -- Gary''s Student - gsnu200753 "thewizz" wrote: 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!!! -- I am not where I intended to go, but I think I am where I am supposed to be! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event
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. -- -John Please rate when your question is answered to help us and others know what is helpful. "thewizz" wrote: 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!!! -- I am not where I intended to go, but I think I am where I am supposed to be! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event
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. -- -John Please rate when your question is answered to help us and others know what is helpful. "thewizz" wrote: 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!!! -- I am not where I intended to go, but I think I am where I am supposed to be! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Change Event
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! -- I am not where I intended to go, but I think I am where I am supposed to be! "John Bundy" wrote: 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. -- -John Please rate when your question is answered to help us and others know what is helpful. "thewizz" wrote: 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!!! -- I am not where I intended to go, but I think I am where I am supposed to be! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Worksheet_Change event | Excel Programming | |||
Worksheet_change event | Excel Programming | |||
Worksheet_Change Event | Excel Programming | |||
Worksheet_Change Event | Excel Programming |