MACRO BUTTONS
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.
|