Examples of well laid out UserForms

[adambc]

I have been using UserForms for a few years now and have developed a style that seems to work well with my Users (I am doing voluntary work for a local charitable organisation) ...

I've got a project at the moment which involves quite a lot of controls (TextBox, ComboBox, CommandButtons) but they all need to be on a single page form ...

Can anyone share any good examples of well laid out "busy" forms to see if there's a style I can mimic please?

Thanks ...

 

[Legacy 143009]

Here is a very simple template. As a user, what I would perefere could be, is to see form controls in the order of data to be input.

 

[adambc]

Here is a very simple template. As a user, what I would perefere could be, is to see form controls in the order of data to be input.
View attachment 79218

Many thanks ...

Pretty much follows the style I use, but I was looking for examples of UserForms that have a LOT more controls?

As an aside, what are using using for your Date Picker?

 

[Legacy 143009]

I think this is a VB project There is no DatePicker in VBA, you are right.

Again if I were you, If there are lots of elements then, I would use a MultiPage element and set its style to TabStyleNone. ı would divide input steps into multiple parts and place a next button which can change the Value of MultiPage element so that it may create the feeling of navigating through the pages.

 

[adambc]

I think this is a VB project There is no DatePicker in VBA, you are right.

Again if I were you, If there are lots of elements then, I would use a MultiPage element and set its style to TabStyleNone. ı would divide input steps into multiple parts and place a next button which can change the Value of MultiPage element so that it may create the feeling of navigating through the pages.

I would usually adopt a MultiPage approach as you say, but on this occasion I have been constrained to a single page by the principal user (long story!) ...