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

macros

ResolvedVersion 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:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.