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!

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!

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!

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!

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!