![]() ![]() I need the code to go from a textbox to a dtpicker. ![]() I wanted to add the calendar in the tab order (which looks like I can only do via code). The user will be in a textbox prior to moving to the calendar. 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. Ensure the Show Developer Tab in Ribbon check box is selected. The Popular options of the Excel Options dialog box. Make sure that Popular is selected at the left side of the dialog box. Excel displays the Excel Options dialog box. Private Sub ComboBox1_KeyDown(ByVal Ke圜ode As MSForms.ReturnInteger, ByVal Shift As Integer) To display the tab if you are using Excel 2007, follow these steps: Click the Office button and then click Excel Options. ![]() 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 |