I am attempting to create an Access-like form on one sheet in Excel which has multiple text and combo boxes. Once all the boxes are filled in, you press a button and it enters the new validated record onto another sheet in the same workbook. I would like to set up a tab order between the text and combo boxes, but cannot find any Tab Index property or any SetFocus methods. What can I do?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Tab between embedded ActiveX Controls
- Thread starter dborden
- Start date
Excel Facts
Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Similar threads
- Question
- Replies
- 3
- Views
- 391
- Question
- Replies
- 50
- Views
- 1K
- Replies
- 4
- Views
- 262
- Replies
- 5
- Views
- 820
- Replies
- 5
- Views
- 473
