Userform choice generates another Userform with various Comboboxes

[bobby.bobby]

Hi everyone,

I am new at VBA and struggling to come to terms with the whole language.

My problem is as follows:

I currently have a UserForm which opens when i open my excel workbook. Within this UserForm there is one ComboBox with three options. I would like to generate a new UserForm depending on the choice made in the ComboBox.

e.g. If "A" is chosen from the ComboBox then another UserFormA should come on. If "B" UserformB...ect

The end result would be that from the second Userform you would be able to make choices which would generate the data from the database...

Anyone know the coding for this, I expect its pretty straightforward...

[Norie]

You could have command button and do something like this.

Please Login or Register  to view this content.

By the way, are the 3 forms completely different?

[bobby.bobby]

Amazing. That's what I wanted to do.

The Three forms aren't completely different, but they each have their own variables with various comboBoxes created from lists from one of the tabs from my excel spreadsheet. Why do you ask?

[Norie]

I was just wondering if you needed all three forms,

If they are pretty different from each other then I suppose you do.