Manual sequence to add a combobox/dropdown/listbox to toolbar

[John Keith]

I have seen some example VBA code that will add a dropdown to a commandbar.
How is this activated manually with-out using VBA?

I have found where you can add the "command" that causes the mouse to swap
into the mode that will then add a dropdown form or control to a worksheet.
But this is not what Im looking for. I want the dropdown to be part of a
custom menu (not a button that activates the command to place one).

For example the "Format Catagory" on the Customize (toolbar) dialog box.
Has some "commands" ... font, font size, style that have a dropdown shown as
a command that can be added... This is the kind of feature i'm looking for.
(perhaps I need to add a custom command before I can add it to a custom
toolbar?)

I figure I'm missing something simple, can some one point me in the right
direction?

 

[Bob Phillips]

You cannot do it without VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John Keith]

K, thanks for the quick answer, Bob.

--
Regards,
John

You cannot do it without VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

do you want some VBA?

--

HTH

RP
(remove nothere from the email address if mailing direct)

K, thanks for the quick answer, Bob.