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

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?
--
Best Regards

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

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


"Raky" wrote in message
...
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?
--
Best Regards