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 with
this macro. Any hints in this one?


--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130835

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

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



"Adam.Effinger" wrote:


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 with
this macro. Any hints in this one?


--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130835

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.

--
Rick (MVP - Excel)


"Adam.Effinger" wrote in message
...

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 with
this macro. Any hints in this one?


--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile:
http://www.thecodecage.com/forumz/member.php?userid=594
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=130835

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



Rick Rothstein;473774 Wrote:
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.

--
Rick (MVP - Excel)


"Adam.Effinger" wrote in
message
...

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
with
this macro. Any hints in this one?


--
Adam.Effinger

------------------------------------------------------------------------
Adam.Effinger's Profile:
'The Code Cage Forums - View Profile: Adam.Effinger'
(http://www.thecodecage.com/forumz/member.php?userid=594)
View this thread:
'How do I add Icon to Toolbar? - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=130835)



--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130835

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.

--
Rick (MVP - Excel)


"Adam.Effinger" wrote in message
...

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



Rick Rothstein;473774 Wrote:
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.

--
Rick (MVP - Excel)


"Adam.Effinger" wrote in
message
...

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
with
this macro. Any hints in this one?


--
Adam.Effinger

------------------------------------------------------------------------
Adam.Effinger's Profile:
'The Code Cage Forums - View Profile: Adam.Effinger'
(http://www.thecodecage.com/forumz/member.php?userid=594)
View this thread:
'How do I add Icon to Toolbar? - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...d.php?t=130835)



--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile:
http://www.thecodecage.com/forumz/member.php?userid=594
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=130835

Thanks a lot!!!


--
Adam.Effinger
------------------------------------------------------------------------
Adam.Effinger's Profile: http://www.thecodecage.com/forumz/member.php?userid=594
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=130835