Hello,
If you have seveal buttons to activate different macros, can you put
all of the buttons into a drop-down?
As always, any help greatly appreciated.

Hi,

Well maybe, sort of. First, where is the drop down - is it in the
spreadsheet, on a toolbar, on a menu, or on a user form? What version of
Excel are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JOHN" wrote:

Hello,
If you have seveal buttons to activate different macros, can you put
all of the buttons into a drop-down?
As always, any help greatly appreciated.

I am using Excel 2007 and I would put the dropDown on the sheet,in the cells
that I want to paste the data.

"Shane Devenshire" wrote:

Hi,

Well maybe, sort of. First, where is the drop down - is it in the
spreadsheet, on a toolbar, on a menu, or on a user form? What version of
Excel are you using?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JOHN" wrote:

Hello,
If you have seveal buttons to activate different macros, can you put
all of the buttons into a drop-down?
As always, any help greatly appreciated.

With the names of your macros in a DV dropdown list.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rtext As String
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
rtext = Target.Value
Application.Run rtext
End Sub


Gord Dibben MS Excel MVP

On Fri, 27 Feb 2009 15:40:01 -0800, JOHN
wrote:

Hello,
If you have seveal buttons to activate different macros, can you put
all of the buttons into a drop-down?
As always, any help greatly appreciated.

Thank you for your help

"Gord Dibben" wrote:

With the names of your macros in a DV dropdown list.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rtext As String
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
rtext = Target.Value
Application.Run rtext
End Sub


Gord Dibben MS Excel MVP

On Fri, 27 Feb 2009 15:40:01 -0800, JOHN
wrote:

Hello,
If you have seveal buttons to activate different macros, can you put
all of the buttons into a drop-down?
As always, any help greatly appreciated.