• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Tab order in excel VBA dialog box

I created a dialog box in excel 95 VBA. I want to change the tab order for the control. Is there a way to change/assign tab order after dialog box creation.

thanks
 
0
sgarg
Asked:
sgarg
1 Solution
 
HATCHETCommented:
sgarg,

Depending on the type of object, look for the ZOrder and/or TabIndex property.  You can change both at design-time via the Properties Window, or programatically at run-time as follows :

OBJECT.ZOrder = X

- or -

OBJECT.TabIndex = X


Good Luck,

HATCHET
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now