Run macro from embedded object

Wingz · Apr 2nd, 2002, 02:18 PM

Just wondering what the code is to run a designated macro from an embedded button. For example, I have a macro "Calc" written in a module and instead of copying and pasting the code into the Button Click sub, can I write a "trigger" that runs that macro?
Basically > Click Button > Button "calls" the Calc macro (and then any other macros I may want to run) Thanks in advance!

willlobb · Apr 2nd, 2002, 02:33 PM

hi, to call the calc macro from a button, you need to create a macro with the code
Call Calc
then, assign this macro to the button.
Will

Wingz · Apr 2nd, 2002, 02:36 PM

No, I don't want to run the macro from a toolbar button, I want to run it from a coded embedded button.

willlobb · Apr 2nd, 2002, 02:38 PM

how d'you mean?

Wingz · Apr 2nd, 2002, 02:40 PM

I want to create a command button on my worksheet. Inside the code of that command button, I want to trigger a macro.

ie.
Private Sub CommandButton1_Click()
"Trigger macro from here"
End Sub

willlobb · Apr 2nd, 2002, 02:46 PM

can i ask why it needs to be within the actual button and not a macro connected to the button?

Wingz · Apr 2nd, 2002, 02:50 PM

That's just it... I want to know If I am able to call other macros from the code in a command button. This way I can call 2 or 3 macros by just clicking the button I have embedded.

willlobb · Apr 2nd, 2002, 02:52 PM

well yes then, you should be able to. have you tried with the call command?

willlobb · Apr 2nd, 2002, 02:52 PM

well yes then, you should be able to. have you tried with the call command?

Wingz · Apr 2nd, 2002, 02:58 PM

That's what I'm after... the syntax. What is the syntax for the call command?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 02:18 PM	#1
Wingz New Member Join Date: Mar 2002 Posts: 33	Just wondering what the code is to run a designated macro from an embedded button. For example, I have a macro "Calc" written in a module and instead of copying and pasting the code into the Button Click sub, can I write a "trigger" that runs that macro? Basically > Click Button > Button "calls" the Calc macro (and then any other macros I may want to run) Thanks in advance!

Apr 2nd, 2002, 02:33 PM	#2
willlobb Board Regular Join Date: Mar 2002 Posts: 103	hi, to call the calc macro from a button, you need to create a macro with the code Call Calc then, assign this macro to the button. Will

Apr 2nd, 2002, 02:36 PM	#3
Wingz New Member Join Date: Mar 2002 Posts: 33	No, I don't want to run the macro from a toolbar button, I want to run it from a coded embedded button.

Apr 2nd, 2002, 02:38 PM	#4
willlobb Board Regular Join Date: Mar 2002 Posts: 103	how d'you mean?

Apr 2nd, 2002, 02:40 PM	#5
Wingz New Member Join Date: Mar 2002 Posts: 33	I want to create a command button on my worksheet. Inside the code of that command button, I want to trigger a macro. ie. Private Sub CommandButton1_Click() "Trigger macro from here" End Sub

Apr 2nd, 2002, 02:46 PM	#6
willlobb Board Regular Join Date: Mar 2002 Posts: 103	can i ask why it needs to be within the actual button and not a macro connected to the button?

Apr 2nd, 2002, 02:50 PM	#7
Wingz New Member Join Date: Mar 2002 Posts: 33	That's just it... I want to know If I am able to call other macros from the code in a command button. This way I can call 2 or 3 macros by just clicking the button I have embedded.

Apr 2nd, 2002, 02:52 PM	#8
willlobb Board Regular Join Date: Mar 2002 Posts: 103	well yes then, you should be able to. have you tried with the call command?

Apr 2nd, 2002, 02:58 PM	#10
Wingz New Member Join Date: Mar 2002 Posts: 33	That's what I'm after... the syntax. What is the syntax for the call command?