UserForm Frames

[wambaugh]

Guys

Is there a way of changing the Order of a frame that was created after the underlying textboxes

I have some 30 text boxes on the form and want to group them in frames but forgot to create the frames before I created the textboxes

Any ideas

Mark

[Norie]

Mark

Can't you select all the textboxes by drawing a rectangle over them and then drag them into the frame?

[Gabor]

First you create a new frame.
Then drag the top of the frame and pull down until you see just a narrow line of it at the bottom of your Form.
It should be visible so mach that you are able to roll your cursor over the body of the frame, not just the frame of the Frame.
Your textboxes will be visible now.
Then select the text boxes you want to be on your Frame, by clicking on the first, hold down Ctrl and clicking on the others one after the other.
Release Ctrl.
Now select the top-most TextBox of the selection, then pull the selection of textboxes down until your cursor is over the Frame.
Release mouse button.
The texboxes now will be in the frame.
Pull your frame back up and re-organise the textboxes inside of it.
That is it.

[Norie]

Gabor

Is it not a wee bit easier to 'draw' a rectangle over the textboxes to select them?

[Gabor]

ummm.....yeah...

[wambaugh]

Mark

Can't you select all the textboxes by drawing a rectangle over them and then drag them into the frame?

tHANKS FOR THATS NEVER THOUGHT OF TRYING THAT

[Norie]

Kind of lost me there, did I offend in some way?