View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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