How to tab from Cells to Buttons on Protected Sheet

[StillOurRefuge]

I basically have a lookup form/sheet. You enter a ZIP Code in the designated cell then click a "go" button and it gives a bunch of info from the ZIP entered.

(Sidenote that may or may not matter: the entire sheet is Protected except for the 1 cell to enter a ZIP Code)

My issue is that after entering the ZIP Code, you must actually click on the "go" button, which means switching from keyboard to mouse every time, just to click a button.

I can't figure out how to enable tabbing from the cell to the button, back to cell, etc., so that you could enter a ZIP code in the cell, hit tab, hit enter - and get results from that.

Any help?

 

[mikerickson]

Have you looked at the Change event?

 

[StillOurRefuge]

Sorry - I'm a real novice at this. Would you be able to elaborate on your question?

 

[mikerickson]

Excel has Events, which can trigger a macro when then happen.
When a cell's value is changed, the Change event fires.

To access this, put a change event in the code module for the sheet in question.
In the VBEditor, in the Project Explorer, double click on the icon for the sheet.
A sheet module will appear.
From the top left drop down, select Worksheet. Then from the right drop down, select Change

This should appear in the module

Private Sub Worksheet_Change(ByVal Target As Range)
    
End Sub

Target is the range object of the cells that have been changed. NB Target can be more than one cell. (Copy Pasting is a common way for Target to be more than one Cell

If you put code like this into that procedure you can see how it works.

Private Sub Worksheet_Change(ByVal Target As Range)
    MsgBox Target.Address & " has been changed"
End Sub

For your case, you could use code like this. (if your Zip cell is A1 and your button calls Button1_Click)

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
        Call Button1_Click
    End If
End Sub

 

[StillOurRefuge]

This method did work to auto-fill my fields when changed, but I was actually just wanting it to move to the button, without actually running that code.

I have a field (cell), then a button, then field, then button, then field, then button.

I simply want to be able to press "tab" and move from field, to button, to next field, to button, etc.

 

[mikerickson]

AFAIK, the tab button won't work that way.