text boxes

  • Thread starter Thread starter NetComm888
  • Start date Start date
N

NetComm888

Hi,
I have some text boxes on one sheet called "interface", linked to
another table called "stage" . In that way, when the client types data
in the text boxes, those info will be linked into the "stage". Then I
have a button called "Enter", which is assigned a macro. So when the
client push "Enter", the macro will copy the stage info into a
permanent table and also clears up the "Interface" and "Stage". It
works fine so far.

But the problem is that there are quite a few text boxes on the
"interface". Clients said they couldn't jump from one box to the next
by "TAB" key. Well I guess "TAB" key is only designed for cells but
not text boxes.

So my question is: Can I alter the "TAB" key by a macro or VBA code to
allow the client jump from one box to the next.

Thanks in advance
 
-----Original Message-----
Hi,

But the problem is that there are quite a few text boxes on the
"interface". Clients said they couldn't jump from one box to the next
by "TAB" key. Well I guess "TAB" key is only designed for cells but
not text boxes.

So my question is: Can I alter the "TAB" key by a macro
Click to expand...
or VBA code to

Once a Text box is selected you can enter text and tab to
the next box. You only need code to select the first box.

Sub TxtBoxTab()
ActiveSheet.Shapes("Text Box 2").Select
End Sub

Regards
Peter
 
One thing that may not be obvious to you in Rob's post is that you will need
to create a separate KeyDown event for each textbox and specify the previous
and next in series for each.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top