Selection Object(button) in excel via VBA

[prajul89]

I have a button in my sheet which is assigned by a macro.
There are some fields in my sheet that needs to be filled up by user.
Once every fields is filled up I want my change_event macro to select the button, so that just pressing {Enter} or {space} can activate my macro.

 

[prajul89]

ActiveSheet.Shapes("Button 155").Select

This does not help at all.
It selects my button to Edit mode or design mode.
What I want is, after this selection of button, pressing only {enter} would run the macro assigned to it.

Does anyone know how to do it.

 

[GlennUK]

What kind of button is this?

 

[prajul89]

Its a normal Button which I have added in excel sheet and assign it a macro.

I have added it Via Developer TAB > Insert > Form control.........

 

[GlennUK]

Why did you choose that type of button instead of an ActiveX Controls button? I didn't think that Forms Controls buttons took focus the way that you want.

 

[prajul89]

Thats okay, if you want I would replace the normal button with ActiveX Controls button.

 

[prajul89]

I have done what you said I have switched my macro to ActiveX button. Now as far as my knowledge is concerned this should work:

Me.CommandButton1.Select

But for some reason nothing is happening.
Can you tell me why???

 

[GlennUK]

In that case it would be:
Sheet2.CommmandButton1.Activate

.... {space} will run the macro for it.

 

[prajul89]

Thanks a Ton, that worked.
Really appreciate your inputs.