Specific cells activate Macro

[soulpeep]

Hi all;

I have some coding in my worksheet that changes the background/text color of a cell, based on the text within it, selected from six options on a dropdown menu.

I'd like to program it as a specific macro that only runs when I change data in the key cells, as right now, every time you perform an action, anywhere in the sheet, the code runs and you can't undo anything.

Anyone know of a way to activate the macro with the drop down menu selection? Or only have the code run when data is changed within those particular columns? (It doesn't matter if you can't undo THOSE changes).

Thanks!

 

[kpark91]

Well, I'm sure you have
Worksheet_Change (ByVal Target As Range) event embedded in your code right now.

If you want a macro to be fired when there's a specific change in column A.
You can use this snippet of code:

If Target.Column = 1 Then
   'Your code
End If

So, what the event does is, It gives you the changed cell reference as Target.
All you have to do is check if the target's column is what you want and execute the code accordingly.

As for activating the macro with the drop down menu.
You can do it by dropDownMenu_Change() event where you could double click your dropDownMenu in design mode or you can do it by checking its values at a click of a button.

 

[soulpeep]

Thanks for the quick reply.

I used the target column function you described and had it call up my old code (which I moved off the worksheet into a module).

I am completely learning by doing here, and that worked great.

Thanks!