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

See Rob Bovey's post on this:

http://groups.google.com/groups?selm...tngp13.phx. g
bl

URL should be pasted into the web browser (all one line)

--
Regards,
Tom Ogilvy


NetComm888 wrote in message
om...
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
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)

"Tom Ogilvy" wrote in message
...
See Rob Bovey's post on this:


http://groups.google.com/groups?selm...tngp13.phx. g
bl

URL should be pasted into the web browser (all one line)

--
Regards,
Tom Ogilvy


NetComm888 wrote in message
om...
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