How do I add Icon to Toolbar?

[Adam.Effinger]

I have a finished-working macro that I want to make it easier to get to
I would like to create an icon in a toolbar to access the userform wit
this macro. Any hints in this one

 

[Patrick Molloy]

Chip Pearson covers this - as do many others of course, all good

http://www.cpearson.com/excel/menus.htm

 

[Rick Rothstein]

Right click a blank area on the Toolbar, select Custom from the popup menu
that appears, select the Commands tab on the dialog box that appeared,
scroll down to the Macros entry in the Categories list, select the Custom
Button item in the Commands list and then click drag it onto the Toolbar.
After you release the mouse button, there will be a new icon on the Toolbar;
next, click the Modify Selection button that is on the dialog box and select
Assign Macro from the popup menu and complete the selection on the next
dialog box to appear. Then click the Modify Selection button again and
select Change Button Image if you want to use a different icon symbol for
your button. You can also play with some of the other items on the popup
menu from the Modify Selection button.

 

[Adam.Effinger]

The solutions that you two have the same problem. They don't sa
anything about a userform (which I use). I couldn't find anything t
solve that.

 

[Rick Rothstein]

What did you mean when you said "access the userform with this macro" in
your original posting? I figured you were already showing the UserForm from
that macro. If not, why not? The line you would need to add to your macro
(presuming it is not already there) is this...

UserForm1.Show

where I am assuming your UserForm is named UserForm1.

 

[Adam.Effinger]

Thanks a lot!!