View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2221_] Rick Rothstein \(MVP - VB\)[_2221_] is offline
external usenet poster
 
Posts: 1
Default 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