assign macro to button programmatically

's Computer Specifications

I have a button on my worksheet from the Forms toolbar. I know I can use
ActiveSheet.Buttons(1).Caption="My Text" to set the button's caption. But
how do I set the button's macro to sub SpeakMsg? Excel XP. Thanks, James

's Computer Specifications

Hi Zone

Sub Macro1()
ActiveSheet.Shapes("Button 1").OnAction = "testB"
End Sub

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP

's Computer Specifications

Many thanks and regards to Munich

"Helmut Weber" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Zone
>
> Sub Macro1()
> ActiveSheet.Shapes("Button 1").OnAction = "testB"
> End Sub
>
>
> --
>
> Greetings from Bavaria, Germany
>
> Helmut Weber, MVP WordVBA
>
> Vista Small Business, Office XP

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Assign a macro to a button	totofab	Microsoft Excel Misc	4	13th Dec 2007 06:16 PM
How do I Assign Macro to a button?	=?Utf-8?B?QmVsbEV4Y2Vs?=	Microsoft Excel Charting	4	20th May 2005 07:21 PM
Re: Assign macro to button	Bob Phillips	Microsoft Excel Programming	0	24th May 2004 04:27 PM
Assign button to run macro	jamie85	Microsoft Excel Programming	8	3rd Feb 2004 01:44 PM
Assign Macro to button	Eric W.	Microsoft Outlook VBA Programming	1	15th Jul 2003 06:25 PM