Controls inside a Frame do not display in design order.
 

My UserForm has a couple dozen controls, mostly command buttons.

Of course, at runtime all controls display exactly where they are in
the designer (unless you reposition them).

Now I want to start using Frames for the first time.

But, when I create a Frame, drag a few existing controls into it--even
keep them in the same order they had on the UserForm--at runtime their
vertical order in the frame is screwed up.

For example, at design time Frame 1 contains, from the top down,
command buttons A, B, C, D. But at runtime it's B, A, D, C.

So what do Frames do? Display controls by the order in which they were
first created?

The only way I've found to defeat it is, starting with the first
control that's out of order, delete it and all controls below it in
the Frame, then re-create them from the Toolbox. What a nightmare.

What am I doing wrong?

Thanks much.

***

Controls inside a Frame do not display in design order.
 

See this topic in VBA help file.

"Set the tab order using the Tab Order dialog box"



"Jim Luedke" wrote in message
...
My UserForm has a couple dozen controls, mostly command buttons.

Of course, at runtime all controls display exactly where they are in
the designer (unless you reposition them).

Now I want to start using Frames for the first time.

But, when I create a Frame, drag a few existing controls into it--even
keep them in the same order they had on the UserForm--at runtime their
vertical order in the frame is screwed up.

For example, at design time Frame 1 contains, from the top down,
command buttons A, B, C, D. But at runtime it's B, A, D, C.

So what do Frames do? Display controls by the order in which they were
first created?

The only way I've found to defeat it is, starting with the first
control that's out of order, delete it and all controls below it in
the Frame, then re-create them from the Toolbox. What a nightmare.

What am I doing wrong?

Thanks much.

***

Controls inside a Frame do not display in design order.
 

JLGWhiz:

OK, thanks much. I will.

***