The only problem is that I have a calender on the form as well. This code would allow me to tab from a textbox to a combo box then to another textbox. Private Sub ComboBox1_KeyDown(ByVal Ke圜ode As MSForms.ReturnInteger, ByVal Shift As Integer) Private Sub TextBox1_KeyDown(ByVal Ke圜ode As MSForms.ReturnInteger, ByVal Shift As Integer) The way around not having the tabindex available as a property, I went into View Code for the textboxes and entered the following code: The only property listed regarding a tab action is the TabKeyBehavior property (which if set to true allows the user to use the tab key within the textbox). If I am in Design Mode (under the Developer tab in the Ribbon) and click on textbox1, then click on properties (top button to the right of Design Mode button), tabindex is not listed. (FYI - in Excel 2007, the textbox form control is no longer available - it is grayed out so the only option for a textbox is an ActiveX control). When my user goes to populate information in the textboxes, I want them to be able to type their answer in textbox1 and then hit the tab key to send the focus to textbox2, etc. I have place ActiveX controls on the spreadsheet (labels, textboxes, combo boxes, etc).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |