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

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?


--
Regards,
John

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

You cannot do it without VBA.

--

HTH

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


"John Keith" wrote in message
...
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?


--
Regards,
John

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

K, thanks for the quick answer, Bob.

--
Regards,
John


"Bob Phillips" wrote:

You cannot do it without VBA.

--

HTH

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


"John Keith" wrote in message
...
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?


--
Regards,
John

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

do you want some VBA?

--

HTH

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


"John Keith" wrote in message
...
K, thanks for the quick answer, Bob.

--
Regards,
John


"Bob Phillips" wrote:

You cannot do it without VBA.

--

HTH

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


"John Keith" wrote in message
...
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?


--
Regards,
John