How to get embedded text boxes and buttons to use the tab key?

[evilrtc]

When you're normally using windows applications you can tab and shift-tab between fields of entry. I'd like my embedded userform to do this in my spreadsheet. When I create a userform on its own and run it as a macro the tabs work fine but the embedded in the spreadsheet version does not work.

Any help would be much appreciated!

[JR@SGC]

Have you tried setting the Tab Index in the properties menu?
Select what you want to tab to in the VBA editor and have a look in the properties menu and you will see its default is 0.

[evilrtc]

I have not been able to find tabindex under sheet1 properties or under properties for the individual text boxes. Am I looking in the wrong place?

[JR@SGC]

When you are editing a userform in the vba editor in excel. Just have alook in the properties of your item e.g. textbox

take a look at the attached

[evilrtc]

I knew I was missing something. Right below specialeffect it goes straight to an option of Tab Key Behavior, which when I play around with it it allows usage of the tab key within the text box.

I don't have tab index or tabstop. I'm using xl 2003.

I do have access to these features in the userform that I created in vba. I do not have these features in the embedded text boxes that I have added to my worksheet.