Tab Order

[aharris2693]

I am familiar with VB 6.0, so I built a form in Excel thinking that it would function in the same way, but I can't seem to find any way to setFocus, or set up any sort of tabs from object to object. I assume there has to be some way to do this. Thanks for any help

 

[xlbo]

The property you are looking for is TABINDEX - this is a property of the individual control rather then the form. Starts at 0 and increments by one to show where a {TAB} will take you next.

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[aharris2693]

Geoff,
Thanks for the info. I think I probably wasn't clear enough on what I was asking. I have built the form on a spreadsheet by adding the objects directly to the page. When I go into properties, there is no tabindex, and when I go into the code builder, I get "Object doesn't support this property or method." The same happens when I use set or get focus. I may need to go back and build my entire form in VB, but since I already have it built, I thought I would try to see if there is any way to get this to work.
Thanks again for any help

 

[xlbo]

aaaaah - in a worksheet - not a userform
Well, in that case, you are quite correct, there is no tabindex property on a worksheet but there should be a gotfocus and lostfocus EVENT for controls toolbox objects (there won't be for forms toolbar objects tho)
There's also a change EVENT which you could probably use to handle transitions between the objects (again for controls toolbox objects only)

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[aharris2693]

Thanks a lot for the help, and sorry again for the ambiguity fo my question.

 

[xlbo]

no problemo

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244