• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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