Monitor a cell through VBA?

[TomWolowiec]

Is there any way to continually monitor a given cell for changes? So what I mean is, at first a cell would be blank, but when a user inputs a number into the cell, then any calculation I want on the cell is run. Having a input box prompt would not work well in this case unfortunately.

[abousetta]

Hi,

You use a sheet-level code:

Please Login or Register  to view this content.

Or workbook-level code (ThisWorkbook):

Please Login or Register  to view this content.

[TomWolowiec]

I'm not sure what that's supposed to do. Looks like I have to manually supply the Target range? Or is that taken from a mouse-click or something?

[abousetta]

Is there any way to continually monitor a given cell for changes?

Yes you can, but you have to tell Excel what that cell is. That will be the 'Target'. So therefore if the 'Target' and the 'Range' you put in the code are the same then something should happen. This is just an example, but your needs may be different.

[TomWolowiec]

How do I tell Excel what the cell is?

I just tried your code where I manually set Target to Range("A1") and it just gave me an error saying "object required". I'm really clueless.

[abousetta]

Take a look at the attachment. Change the value of cell A1 and C1 trigger Msgboxes.

abousetta

[TomWolowiec]

Okay cool, that works. Thanks. I think I can figure it out from here hopefully.

[abousetta]

Glad I could help. PM me if you need further assistance.

Good luck.

abousetta