Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Running macro automatically

Running macro automatically

ResolvedVersion 2010

Tue 2 Sep 2014, 11:30 Delegate Raani said...

Raani has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Running macro automatically

Hi Best STL,

Is it possible to run a macro automatically ie without the use of a command button?

I want to say:

When the value of B2 is 'New' then the value of C2 becomes 'N/A' otherwise it is left blank for the user to complete.

Thanks for your help

Raani

Tue 2 Sep 2014, 11:49 Trainer Andrew said...

RE: Running macro automatically

Hi Raani

Thank you for your question - I have found a Microsoft Knowledgebase article that addresses exactly that question.

http://support.microsoft.com/kb/213612

Let me know if this helps or if you have any further questions.

Kind regards,
Andrew

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips

Running macro automatically

Running macro automatically

RE: Running macro automatically

Excel articles

Excel tip:

Showing all menu items