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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting Tab Index for Text Fields 3
textbox insertion point. 1
vba macro that allows insertion of symbols at cursor 0
textbox's exit event 1
iterate through textboxes on sheet 2
From WebPageA to WebPageB: Error . . . windows opener document isnull or is not an object 1
TextBox exit routine 2nd try 3
First textbox in form not accepting input properly 4

Back
Top