Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
no tab index property in VBA for text fields
Hello all,
I have created a microsoft excel program which uses visual basic text fields on a worksheet. My problem is that when I hit the tab key I don't know how to set the focus to the next text field without having to look at the keyascii for every field. I know in VB6 there is a tab index property for every text field but this doesn't exist in excel form fields. Can someone please help shed some light on how to set a tab index in excel text fields? Thanks, Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
no tab index property in VBA for text fields
Not sure what you mean by "text fields".
Forms Toolbar has no Text Box Controls Toolbar does have a Text Box but AFAIK tab does not work (?) If you are using worksheet Cells you can control tabbing to some exten by unlocking input cells and protecting the sheet. This works left t right then down. If you are using a Text Box from the Drawing Toolbar tabbing works lef to right then down depending on where the top is. One of the text boxes has to be selected first for this to work. If you have set up a UserForm in the VB Editor tab order can be se using View/Tab Order -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
no tab index property in VBA for text fields
Hi Brian,
Thanks for responding. I am using the constrols toolbar textbox. When I place 2 text boxes on the form, I want to change the focus from text1 to text2 when the tab or enter key is pressed but I can't seem to get this functionality as I could if the text boxes were on a proper form. Can you please help? Thanks. P.S. I don't know what AFAIK means. "BrianB " wrote in message ... Not sure what you mean by "text fields". Forms Toolbar has no Text Box Controls Toolbar does have a Text Box but AFAIK tab does not work (?) If you are using worksheet Cells you can control tabbing to some extent by unlocking input cells and protecting the sheet. This works left to right then down. If you are using a Text Box from the Drawing Toolbar tabbing works left to right then down depending on where the top is. One of the text boxes has to be selected first for this to work. If you have set up a UserForm in the VB Editor tab order can be set using View/Tab Order. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set text property of a check box to value of a cell? | Charts and Charting in Excel | |||
Excel Pivot Table, Property Fields | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
File/custom Property fields | Excel Discussion (Misc queries) | |||
unable to set the OnAction Property of the Text Box | Excel Programming |