Macro to Fire when Range("C1") is modified

I want to have a macro fire upon a certain event: Range("C3") is changed. How would I program this?

If Target.address=$C3$ then
'''do something

Need to put AB33's code inside ThisWorkbook and apply it to the Worksheet_Change event

How do I apply it to worksheet change event?

First you have to put the code listed below in the right place. Make sure you click on the correct VBA project and then click on the 'This Workbook' option. See the file below.

This Workbook..JPG

Please Login or Register  to view this content.

bstier

Sorry, The code worked just fine when I changed C3 but when I changed any other cell I would get an error. So here is the corrected code to ignore the change to other cells.

Please Login or Register  to view this content.

I got in a hurry before and didn't check to see if the code worked properly when I changed a cell other than C3. When I did this after the post I realized that the code was crashing. Since we don't care about the change of the other cells I used an On Error Goto statement to fix this. AKK9 caught this as well as I did but I have had trouble all afternoon with the Excel Forum site not showing all posts and allowing me to make timely corrections. Thanks for the double check AKK9

Anyway, this code should be in the Sheet1(Sheet1) and not the ThisWorkbook. Thanks Marcol

Please Login or Register  to view this content.

Originally Posted by Marcol

Why not use this in the worksheet module?

Please Login or Register  to view this content.

When you use the workbook module, you also have to define the sheet it has to apply to.

For example

Please Login or Register  to view this content.

Thanks for pointing this out, putting it in the Sheet module rather than ThisWorkbook is def. the way to go