Change load sequence for dynamic loading userform

[nigelog]

Hi

the attached section of a workbook dynamically loads info to a userform. Now that I have had to add 4 more items of data it has become unwieldy and it would be much better if last 4 headings would load dynamically under one another as there will never be more that 8 of each maximum

the form presently loads 8 columns so it would need to load columns 1 - 3 as per is and then column 4 loading the remaining heading label and data one after another

The code was created by a member here and is above my abilty, I would appreciate if someone could take a look

rgds

[nigelog]

by playing around with settings I have managed to place the first 4 columns in the desired place in userform. Basically the first 3 columns can be handled by the code as is but column 4 needs to first place header label followed by entries from work sheet THEN place label 5 below last entry followed by next etc to last label. Attached workbook might make things clearer. Any help appreciated.

Please Login or Register  to view this content.

[nigelog]

By trial and error I can place the header labels in the column with the approximate required spacing. To load the labels and textboxes is there a way I can reference the position of the header label itself to space the data below its own label.

[Greg M]

Hi again,

Thanks for your private message re the above.

See if the attached version of your workbook does what you need.

Regards,

Greg M

[nigelog]

Perfect, you are a gentleman Greg

Pint for you when next in Dublin...

Will mark as solved

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M