Userform Textbox Sorting

I have 6 textboxes that get filled with text by another control. I want them to go in order from 1 to 6 accross the form. If there is no text in the text box Visible = false.

Examples:
If textbox3 is filled and textbox1 is filled next then I need textbox1 to be put in front of textbox3.

So if the textboxes were filled in the following order 1 2 6 4 3 they would be rearranged to be 1 2 3 4 6.

This is confusing I know. Here is my lamens code to what I think should happen.

For textboxes that visible = true
those textboxes order = 1 to 6

If you need clarification please ask.
Thanks,
Mike

This is the code I'm using to put one box after another but I can't figure out how to sort them.

Please Login or Register  to view this content.