Re: Simplified direction to Automatically run Macros when a cell changes
Thanks for your help - how long do these posts stay online so I can refer back to them or should I copy the codes so I can refer to them. Where do I copy them to?
Posts by Matt Gaffner
-
-
Re: Simplified direction to Automatically run Macros when a cell changes
Sorry, another question. Will the last one you gave me work by itself or do I need to add it to the one before?
-
Re: Simplified direction to Automatically run Macros when a cell changes
Thank you so very much, I shall have some fun now!
-
Re: Simplified direction to Automatically run Macros when a cell changes
So, if I'm understanding this right, 14 could run my fourteen macro, 15 could run my fifteen macro and so on...
-
Re: Simplified direction to Automatically run Macros when a cell changes
Also, would I be able to run a different macro from this same cell if say the number 16 were entered?
-
Re: Simplified direction to Automatically run Macros when a cell changes
GREAT! Exactly what I wanted! (I would have replied sooner, but my window didn't pop up)
THANK YOU! -
Re: Simplified direction to Automatically run Macros when a cell changes
I'm a little slow... I need it spelled out.
When I put "14" in cell C5 I want my macro named "fourteen" to run -
The guide to "Excel VBA: Automatically Run Excel Macros When a Cell Changes/Enter Data. Worksheet Change Event" was helpful in getting me started, but I couldn't do what I wanted. Here is what I want: When I type in data to a cell and press enter, I want a previously created macro to run.