jump from cell content to command button

[VBABEGINER]

Hi,

How to jump from cell content to command button?

i am entering value in cell b10. after click on tab button, can cursor go to command button? and then i put addition code of cells on click event of command button.
Pressing the enter button, command button gets clicked.

I dont know, whether this possible or not.

Any one know this?

 

[sijpie]

you cannot give a command button in a sheet the focus (unlike the buttons on a form), so you cannot activate the button with the Enter key.

What you could do is after the user has changed B10 show a form (or even a simple yes / no messagebox) which will run the same macro as is under the command button in the sheet.

Or if the macro needs to run anytime the user has made a change to B10, then rather than show a messagebox, run the macro immediately.

Right-click on the name tab of the sheet with B10, select 'View Code...'

The macro editor will open on the sheet module (code that is private to this sheet). Paste the following code into the editor. Then go to the sheet and make a change in cell B10.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim mbAnswer As VbMsgBoxResult
    If Not Intersect(Range("B10"), Target) Is Nothing Then
        mbAnswer = MsgBox("Do you want to run the macro?", vbYesNo, "Please select what to do")
        If mbAnswer = vbYes Then
            ' Run macro, enter name of macro here
            MsgBox "Run a macro instead of this stupid message box"
        End If
    End If
End Sub