Tab to next textbox 1

[RicOO1]

I have a series of 20 textboxes that are on my spreadsheet and would like to be able to hit the <Tab> key after I have entered the required data and move from textbox to textbox without having to actually point and click the mouse on the next box. Any ideas?

Thanks for any help,

RicOO1

 

[lars7]

Hi,
If you ment Form, then on the toolbar go to View, then Tab Order and when the box appears arrange them to suit.

 

[TheAceMan1]

How are ya RicOO1 . . .

Note that your in the [blue]Microsoft: Access Forms Forum![/blue]

Exactly what problem are you having with Tab?

If your talking access and the Tab Order is out wack, have a look at the tab order: [blue]MenuBar - View - Tab Order[/blue] and adjust there . . .

See Ya! . . . . . .

 

[RicOO1]

I guess I posted in the wrong forum. It is just a regular old spreadsheet but with some textboxes added and I want to be able to <Tab> from textbox to textbox and also work in the other spreadsheet cells (without using any macros).

Ric001

 

[selfri01]

Ric001, did you ever find a resolution to this issue? I am also trying to setup tab to go from textbox fields in Excel.

Thank you.

 

[RicOO1]

selfri01

I got a response on another Site, the code is shown below. Where it shows ("Sheet3") you put the name of your sheet etc. The only problem I found was that with the 195 Textboxes I have it uses up a bit of memory and really slows the program down (especially closing/saving it). Hope it works good for you.

Ric001

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

Dim TxtBox As Object

If KeyCode = vbKeyTab Then
Set TxtBox = Worksheets("Sheet3").Shapes("TextBox1")
TxtBox.OLEFormat.Activate
End If

End Sub