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
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Similar threads
- Question
- Replies
- 3
- Views
- 386
- Question
- Replies
- 50
- Views
- 1K
- Replies
- 4
- Views
- 252
- Replies
- 5
- Views
- 816
- Replies
- 5
- Views
- 467
