Creating a "complex" userform

Hello everyone. So over the past few weeks I have created an automation which performs a specific accounting task. And this automation was "put" into an excel spreadsheet and the user executes the automation via buttons. Rather than use buttons on a spreadsheet I would like to use a userform. I have created the user form and here is how it looks: First there is a "Multipage" form with 5 tabs. The first tab is just a text box and I would like to put some instruction within the text box. On each of the other tabs there is a button and a text box. Now within each text box I want to put some instruction and help comments and each button needs to be tied into a piece of code: for example Module 4 Main. Any Suggestions? Thanks.

What kind of suggestions do you need?
I probably use labels instead of text boxes if the end users will not be putting data in. You can either assign text to labels or textboxes when viewing the form object and using the properties -> value property for a text box or properties -> caption property for a label. You can also assign then when the form loads using the form_initialize event.

To run another sub from a button, just put the name of the sub on a line of code. You can also use the Call statement.

It looks to me like you have it set up right. Then to call main you'd just put that in the button code like so:

Please Login or Register  to view this content.

As long as you don't have anything else named Main, that is all you need to do.

That's fine, but be aware that there are many changes you can make to controls on a form by looking at the properties. For instance, whether using a textbox or a label, the BackColor property allows you to define the background color. You can change the style of the back color to transparent or opaque, you can change the font of the text, the text alignment, etc. You can also add a special effect, such as making the label/textbox raised, sunken, etched, etc.