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

  • Thread starter Thread starter Raky
  • Start date Start date
R

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?
 
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
 
Back
Top