Macro question. help me make the enter key triger macro

[pedie]

is there i way I can make the enter key triger the macro after i write/paste the name on the activex textbox1. Thank you.

 

[pedie]

is there i way I can make the enter key triger the macro after i write/paste the name on the activex textbox1. Thank you.

Please help

 

[jim may]

Have considered maybe placing a Commandbutton under your textbox1 with the Caption Run Macro

Private Sub CommandButton1_Click()
Dim s As String
s = TextBox1.Text
Run s     'calls any Macro previoulsy set up (in Module1) with this name
End Sub

 

[pedie]

Have considered maybe placing a Commandbutton under your textbox1 with the Caption Run Macro

Private Sub CommandButton1_Click()
Dim s As String
s = TextBox1.Text
Run s     'calls any Macro previoulsy set up (in Module1) with this name
End Sub

i'M not very good in this macro thing.
So the macro in the textbox will triger the macro in the command button?

now i make my macro run when i hit the command button.

 

[jim may]

As you requested - type or paste into your textbox a Macro name. This text in the Box is just text - it will stay there until you overwrite it with other test (another macroname) or close the form. Nothing will happen (a macro will not be triggered) by pressing the enter key within the textbox.

You need to ADD a new control - an Active-X CommandButton with the Caption "Run Macro" - and the code I provided you should be associated with this button. When you Click the CommandButton you are telling Excel to Run a Macro that has that name.

 

[pedie]

Thank you Jim...Thanks alot!