How make macro run if entry made in a particular cell

**Launchnet** · 09-19-2010, 07:18 PM

I have a macro that works perfect. What I want is for this macro to be run when a new value has been entered into cell D9.

Is there such a function that can be used for 1 cell only, such as "On_Enter" ?

**TMS** · 09-19-2010, 07:30 PM

Look at the worksheet change event

Please Login or Register  to view this content.

Regards

**Launchnet** · 09-19-2010, 07:41 PM

What or how does this macro get activated ?

I call my macro from your macro and when I make an entry into D9, nothing happens.

Then I placed Stop after row 2 and the macro does not even start.

**TMS** · 09-19-2010, 07:48 PM

Copy the event code above
In your Excel workbook:
Right click on the tab for the sheet where you want the event trapped
Choose "View Code"
Paste the code

Close the VB Editor

Make a change to cell D9

Regards