command button dropdown

[mdshotgun]

hello,

Is it possible to put command buttons in to a dropdown list.if you have more than 1 button on a sheet.can you make a list of these.Or is this a stupid question?.If it is i apologise.

[opsman]

To answer your question first, it sounds feasable that you could link the selection in the drop down to the code behind your button although it's not something I've attempted yet.

A more straight forward method may be to create shortcut buttons on your toolbar?

[Palmetto]

Is it possible to put command buttons in to a dropdown list.

No. This is not possible. A command button is a control object as is the drop down itself. Combox Box and List Box controls only accept a string (source/method) can vary as the list source for items in the list.

if you have more than 1 button on a sheet.can you make a list of these

It is possible to make a list of the buttons. However, it seems pointless to write code to create such a list since you can simply make one manually. If you have so many buttons that you need to automate the list creation, then you should take a close look at your design and look for opportuntities to improve it.