Thread: text boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NetComm888 NetComm888 is offline
external usenet poster
 
Posts: 4
Default text boxes

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