VBA Programming Series...11 - IT Skills

This blog is for IT lovers, accounts and finance executives who want to add value in their professional life.

test

Welcome to our blog. This blog is for IT lovers, Accounts/Finance Executives who wants to add value in their career path.

Search This Blog

Monday, 21 May 2018

VBA Programming Series...11

test

Executing the procedure from the Macro dialog box


Most of the time, you execute Sub procedures from Excel, not from the VBE. The following steps describe how to execute a macro by using Excel’s Macro dialog box.

1. Activate Excel.

Alt+F11 is the express route.

2. Choose Developer➪Code➪Macros (or press Alt+F8). Excel displays the dialog box shown in Figure.

3. Select the macro.

4. Click Run (or double-click the macro’s name in the list box).

No comments:

Post a Comment

Popular

Welcome to our blog. If you want to; learn writing skills, preparation for CSS/Corporate laws, IT skills, downloading Business/IT books, and many more; this blog is for you.