Run macro when entering a value in one of two colums

**Brammer88** · 03-26-2013, 04:52 PM

Hello all,

I am just starting out with vba macros and so far it worked out pretty well, but now i have ran into a concrete wall with this one;

What I want to do is run a macro when I put a value into a column (either column K or M) also the macro that will run in this instance needs to use some
information of the particular row in which the change takes place. So for example I will enter a value in cell k18 and the macro will run using information of row 18.

Can anyboy help me with this one?

Thanks a million!

**xladept** · 03-26-2013, 07:29 PM

Hi Brammer,

You want a Worksheet_Change event:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select Your Worksheet from the Insert menu

Type "Option Explicit" then paste the code under it

and you're ready to go!

Do you know how to put the row as an argument in YourMacro? If not maybe you can post your macro and I'll code it for you