Textbox inserted on an Excel sheet does not allow TABINDEX or SetF

[Raky]

I designed a sheet with textbox and combobox elements on in, so it looks like
a form. Now I had to learn that it is not possible to get the cursor
positioned on the textbox (doing so within a form SetFocus is available) when
opening the sheet and it's not possible to jump into the next defined textbox
by using the TAB-key.
Does anyone know how to deal with this?

 

[Rick Rothstein \(MVP - VB\)]

You can select the TextBox in code like this...

ActiveSheet.Shapes("Text Box 3").Select

where you use the TextBox's name (in quotes) as the index into the Shapes
collection.

Rick