Tabbing from cell to textbox

[Bargos]

Hi everyone,

I hope you are all well.

Im working on a protected spreadsheet that has a combination of textboxes and cells in which I need to be able to tab from a cell to a textbox and back again.

I can tab from a cell to a textbox ok by working out what cell the tab key *should* have taken the cursor to and then using textbox1.activate to put the cursor where I want it.

The problem is that the focus of the spreadsheet is not at the textbox that I have redirected it to and logically enough it is still at the cell that it would have been until I redirected it. I naturally assumed that 'textbox1.setfocus' would work to line things up but I textbox1 does not seem to have that method associated with it.

Any ideas please?

B.

 

[Andrew Poulsom]

Here's an example:

http://www.mrexcel.com/board2/viewtopic.php?t=87996

 

[Bargos]

Thanks Andrew.

However my code looks similar to this anyway :

dim lastcell as string

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Select Case Target.Address
Case "$F$12"
lastcell = "F12"
Case "$D$39"
If lastcell = "F12" Then
TextBox1.Activate
End If
End
End Select

Textbox1 lies in the tab order between F12 and D39 so, when Im in F9 and hit the tab key the cursor moves to D39, works out that it should be in textbox1 and moves it there. The problem is that the focus is still at D39 although the cursor is in textbox1, offscreen.