VBA worksheet change event to launch macro??

[joeshu26]

Hi,

I am need my macro SORT_SAP1 to launch if cell "P12" changes. Can some one help me with the correct syntax for the worksheet change event?

Thank you!

 

[AlphaFrog]

Note: The Worksheet_Change event triggers from a user change (not from a calculation).

[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Sub[/COLOR] Worksheet_Change([COLOR=darkblue]ByVal[/COLOR] Target [COLOR=darkblue]As[/COLOR] Range)
    [COLOR=darkblue]If[/COLOR] Target.Address(0, 0) = "P12" [COLOR=darkblue]Then[/COLOR] SORT_SAP1
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]

 

[joeshu26]

It doesn't seem to work, but maybe it because Worksheet_Change is not the appropriate method?

I have a Combo Box (Form Control), and based on the value I select a number populates in cell "P12", so that when the number changes I need my macro to run...

 

[AlphaFrog]

It doesn't seem to work, but maybe it because Worksheet_Change is not the appropriate method?

I have a Combo Box (Form Control), and based on the value I select a number populates in cell "P12", so that when the number changes I need my macro to run...

Right-click on the Form control combobox and assign your macro to it. You wouldn't need the worksheet_change event procedure.

 

[joeshu26]

Awesome it worked, thank you!