MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

UserForm Objects (?)

  Asked By: Norma    Date: Sep 05    Category: MS Office    Views: 2339

How does a Userform know when objects are created ?
You can create a Userform with objects in sequential and placement order (i.e.,
OptionButton1, Optionbutton2, TextBox1, TextBox2 )
If later on, I need to add another object and place it in the middle of the
Then, this last object added was created last and causes the ( TabIndex )
numbers to be out of sequence.

Why can't VBA code going thru a Userform of objects see that the objects
are in placement order, rather than in creation order ?



1 Answer Found

Answer #1    Answered By: Sallie Hill     Answered On: Sep 05

I believe that I finally found a way:
use the SetDefaultTabOrder.
It orders the control from left to right, top to bottom.
You may need to make some adjustments if you have a frame and other controls
on the same horizontal level.

Didn't find what you were looking for? Find more on UserForm Objects (?) Or get search suggestion and latest updates.