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

macros

ResolvedVersion 2007

Robert has attended:
Excel Advanced course

Macros

How do i attach a macro to a button?

RE: Macros

Hi Robert,

Thank you for your question.

If you go to the Developer tab and then choose the Insert option from the Controls group.

Add a grey button from the Form controls toolbox. When you have finished drawing your button a dialogue box will appear asking you which macro you want assigned to the button.

I hope this answers your question.

Regards

Simon

Mon 16 Nov 2009: Automatically marked as resolved.

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

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.12 secs.