How to design a Userform with about 60+ elements

[sumit dey]

Hi Everyone,

I hope everyone's doing fine.

I have created a workbook with a userform in it for MIS purposes. It's working fine....

But, I would have to insert a large number of textboxes, Labels and other components on the userform as the original worksheet would have about 60 rows to fill (about 17 of them would have dates not in sequence) this won't look great...So, I am looking for any other alternative to this userform design or an entirely different userform (say multipage but, I have never used it).

I would be thankful to anyone who can help here...

Cheers!!!

 

[Nebu]

Hi:

I would recommend you to use multipage, try to group the fields based on common attributes and group them into different pages. I guess it will serve your purpose.

Thanks