VBA Excel using buttons to run macros question

[knifey]

Hi,
I'm a VBA complete beginner and would like to know how to assign a macro to a button, simple?
My problem is I don't know how to create the button in the first place (is the button created as a picture or someting else?) Can anyone point me in the right direction?
Thanks,
Roy

 

[Fenrirshowl]

Look at the View menu...toolbars...forms toolbar. You will find a button on there. Once you add it to a sheet, right click and assign a macro to it!

Happy Xmas

Fen

 

[AnotherHiggins]

Search Excel's help file for Customize menus and toolbars.


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

Sorry - I pressed Submit too soon.

Do you want a button on the sheet itself, or do you want a new button in a custom toolbar?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[knifey]

Thanks Fen,
Works like a treat!
Happy new year,
Roy