Sir Babydum GBE
08-08-2011, 09:31 AM
Hi
I would like to have a macro that looks at what information is being input into column K.
The inputter has a list of things to choose from a validation dropdown. If he chooses "Option3" or "Option4", i need it to execute code that I have written (different code for both options).
I would later like to be able to add options that might trigger different code lines
It should do nothing if other options are selected.
So how do I do it?
Thanks very much
BD
I would like to have a macro that looks at what information is being input into column K.
The inputter has a list of things to choose from a validation dropdown. If he chooses "Option3" or "Option4", i need it to execute code that I have written (different code for both options).
I would later like to be able to add options that might trigger different code lines
It should do nothing if other options are selected.
So how do I do it?
Thanks very much
BD