MACRO BUTTONS

  • Thread starter Thread starter JOHN
  • Start date Start date
J

JOHN

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?
 
I am using Excel 2007 and I would put the dropDown on the sheet,in the cells
that I want to paste the data.
 
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
 
Thank you for your help

Gord Dibben said:
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
Click to expand...
 
Back
Top