Custom popup button on toolbar

[Kristina Conceicao]

Via VBA, I have created a custom toolbar that has a quite a few regular
buttons, plus a popup button that contains several choices. Each choice
runs a different macro. I'd like to make the user's last choice from
the popup button "stick" for reuse. For example, when using the built
in popup button for font color, if you select red, the button
"remembers" this choice. You are then able to simply click once on the
button to make text red, without having to pick red from the popup each
time.

Is anyone aware of a way to do this? I realize I could make separate
buttons for each macro, but screen real estate is an issue. I develop
in Excel 2004, but most of my end users are still running Excel 98.

Thanks in advance for any help!

Kristina

 

[Kristina Conceicao]

Update:

I was able to figure out how to simulate what I want, by creating both a
button and a popup. The popup has no icon or caption, so it appears
only as a little triangle. The button immediately preceeds it. By
calling code with the popup's .OnAction property, I am able to change
the properties of the button.

This does a decent job of doing what I want. But if there's a "built
in" way to do this, I'd be interested in learning about it. If not, I'd
like to see MacBU implement this capability in the future.

Kristina

 

[JE McGimpsey]

I was able to figure out how to simulate what I want, by creating both a
button and a popup. The popup has no icon or caption, so it appears
only as a little triangle. The button immediately preceeds it. By
calling code with the popup's .OnAction property, I am able to change
the properties of the button.

This does a decent job of doing what I want. But if there's a "built
in" way to do this, I'd be interested in learning about it. If not, I'd
like to see MacBU implement this capability in the future.

That's the only way I know of to do it, too, Kristina.

 

[Kristina Conceicao]

That's the only way I know of to do it, too, Kristina.

Thanks, JE. I'll send feedback via Excel, and maybe MacBU will be able
to implement this functionality at some point in the future.

Kristina