Ravindra BagaleCourses & study guides मराठी Track your progress

12. Macros and VBA

12.3 Running Macros: Button, Shortcut and the Macros Dialog

By Last updated:

Steps in Excel

  1. Macros dialog: Developer › Code › Macros (Alt + F8) › select › Run. Options… sets or changes the shortcut key.
  2. Shortcut key: use Ctrl + Shift + letter – plain Ctrl + letter can override Excel shortcuts like Ctrl + C.
  3. Button (Form Control): Developer › Controls › Insert › Form Controls › Button › draw it › the Assign Macro dialog opens › choose FormatDailyReport › OK › right-click › Edit Text "Format Report".
  4. Any shape as a button: Insert › Illustrations › Shapes › draw a rounded rectangle › type text › right-click › Assign Macro…
  5. Quick Access Toolbar: File › Options › Quick Access Toolbar › Choose commands from: Macros › Add › Modify… to pick an icon.

Worked example. On the Report sheet Zoya adds three shape-buttons: Format Report, Split by City, Combine Sheets, each assigned to a macro from 12.12 – the Nashik store manager can run them without opening the VBA Editor.

Ravindra Bagale's Tip

If you give a macro the shortcut Ctrl + C or Ctrl + V, Excel's copy-paste stops working – and many students can't figure out why! Always use Ctrl + Shift + a letter. Write a clear name on the button ("Format Report"), not "Button 1" – the user should know what will happen.

Worked example — running macros button shortcut and the macros

Why

Sana Sheikh in Pune and Anna Kowalski abroad both need a clear, repeatable way to use running macros button shortcut and the macros on a QuickCart Delivery sheet without breaking totals.

What

Running Macros Button Shortcut And The Macros is the Excel idea this page teaches. We will walk one tiny example end to end.

How

  1. Open a blank sheet. In A1 type a short label for running macros button shortcut and the macros.
  2. Enter a small made-up value for Sana Sheikh using $ where money appears.
  3. Add a second value for Anna Kowalski using £ so you see mixed currencies stay numeric.
  4. Apply the method from this lesson step by step (menu or formula as shown above).
  5. Check the result still works inside SUM or a simple check cell.

Formula / action

Follow the formula or ribbon steps shown in this lesson (keep values numeric).
Result: The demo cell shows the expected result for QuickCart Delivery's sample row.
Meaning: Once running macros button shortcut and the macros is correct on one row, copy the same pattern down the column.

Practice tasks (10+)

Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.

1. Rebuild the smallest example of running macros button shortcut and the macros on a blank sheet for Summit Schools.

Hint: Use only the steps on this page. Keep numbers numeric.

2. Change one input for Vikram Rao and confirm the result updates.

Hint: If the result is stuck, check absolute vs relative references.

3. Repeat the same steps with a £ or € value for Sophie Martin.

Hint: Formatting must not break SUM.

4. Write the result meaning in one plain sentence next to the cell.

Hint: Imagine explaining it to a new joiners.

5. Add a second row and fill the method down.

Hint: Double-click the fill handle if the pattern is consistent.

6. Break the example on purpose, then fix it using this lesson.

Hint: Common break: text instead of a number.

7. Apply running macros button shortcut and the macros to a 5-row made-up Summit Schools table.

Hint: Keep column headers clear.

8. Check your answer with a simple total or COUNT.

Hint: A wrong total usually means a format or key mismatch.

9. Swap ₹ and $ on one column and re-check totals.

Hint: Stored values stay the same; only the display changes.

10. List two mistakes beginners make with running macros button shortcut and the macros.

Hint: Look back at the tip box on this page.

11. Teach the steps out loud in under one minute.

Hint: Why → What → How.

12. Save the sheet as SummitSchoo_practice.xlsx.

Hint: Use a clear file name for class.

Loading practice tasks...

  1. Last used row (Easy): Which row number is the last filled row? The headings are in row 1.
  2. Late orders (Easy): How many rows have Status "Late"?
  3. Total amount (Easy): Add up the Amount column.
  4. Worst delay (Easy): What is the largest number in the Days late column?
  5. Late orders in Pune (Medium): How many orders are Late and in City "Pune"?
  6. Customer for an order (Medium): Find the Customer for Order ID "DL-704".
  7. Money stuck in late orders (Medium): Add up the Amount column for rows where Status is "Late".
  8. Big orders (Medium): How many rows have an Amount of 2000 or more?
  9. Message text (Medium): Build the text "N late orders", where N is the count of Late rows.
  10. Average delay of late orders (Hard): What is the average Days late for rows with Status "Late"? Round to 1 decimal.
  11. Tag for the first row (Hard): For the first row, return "Chase" if Days late is 3 or more, else "OK".
  12. Warning or all clear (Hard): Return "Warning" if any order is 3 or more days late, else "All clear".

See all practice tasks in the Task Hub →

Quick revision cards

Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.

Revision card 1: What is Running Macros Button Shortcut And The Macros?
Card 1: What is Running Macros Button Shortcut And The Macros? · Download PNG
Revision card 2: Tiny example — Running Macros Button Shortcut And The Macros
Card 2: Tiny example — Running Macros Button Shortcut And The Macros · Download PNG
Revision card 3: Checklist — Running Macros Button Shortcut And The Macros
Card 3: Checklist — Running Macros Button Shortcut And The Macros · Download PNG