macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

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

Macros

How do I put a button on the worksheet for a macro?

RE: Macros

Hello Richard

Thank you for your question and welcome to the forum.

You can add a button to your worksheet to run a macro by doing the following:

1. Bring up the Forms toolbar on your screen (View - Toolbars - Forms).
2. Select the Button object from the toolbar.
3. Use your mouse to draw a button on the spreadsheet by clicking and dragging diagonally.
4. When you release the mouse, the Assign Macro dialogue box will automatically pop up. Enter a name for the button and select the macro you wish to run when the button is clicked.
5. Click OK.

I hope this helps.
Amanda


 

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips


Server loaded in 0.08 secs.