Thread: text boxes
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter Atherton[_16_] Peter Atherton[_16_] is offline
external usenet poster
 
Posts: 11
Default text boxes


-----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