Multiple Select Case to open exact UserForm

[Colin Smit]

Hi There...

With the help of this Forum I have managed to get a User Form working where a selection are done through a Combo Box and based on the selection another User Form is then opened for the relevant entry.

The code working for this selection can be seen below. The first code adds the dropdown list for an exact entry.

Please Login or Register  to view this content.

The second part of the code seen below opens the required User Form based on the Combo Box selection.

Please Login or Register  to view this content.

How do I do a multiple selection. The newly planned User Form opened will have a selection between an Area (combobox1), Employee Absent (combobox2) as well as Quantity Employees Absent (combobox3). The code for all the Combo Boxes can be seen below...

Please Login or Register  to view this content.

I have tried numerous ways to alter the select statement with no success. Anyone knows how to add to below code to get it to work?

Please Login or Register  to view this content.

[romperstomper]

I don't really understand what you're asking - what determines which form is loaded?

BTW, you can simplify and speed up your code using arrays:

Please Login or Register  to view this content.

[Colin Smit]

I don't really understand what you're asking - what determines which form is loaded?

I would like to have at least the first 2 Combo Box selections to determine the form. The first selection (combobox1) is for the area. After this selection then only the User Form relevant to that area must be an option. Then based on the selection from combobox2 (Employees Absent Yes or No) the Form for the specific area has one User Form with no absenteeism while the other one has an option to fill in the persons absent.

I have seen some samples on the net for Multiple Selections but could not get it to work with an exact match.

[romperstomper]

Still not really clear but at a guess you mean something like this:

Please Login or Register  to view this content.

[Colin Smit]

I think your code is going the right way as it makes sense and is in line with what I saw on the net.

At the end of the code I get an error "Compile Error: End Select without Select Case" but are not sure to what it must be changed to?

[cytop]

As far as the compile error goes, you've got mis-matched control structure and are probably missing an 'End If' or 'End With'.

Post your code exactly as you have it now...

[romperstomper]

Please copy and paste the exact code you have currently.

[Colin Smit]

See code below...

Please Login or Register  to view this content.

[romperstomper]

That's not my code. You are missing two End If lines there, or one and use ElseIf:

Please Login or Register  to view this content.

[Colin Smit]

That's not my code. You are missing two End If lines there, or one and use ElseIf:

Please Login or Register  to view this content.

That sorted the code error out. However nothing happens as the form does not open.

I have below code on the command button. Do I need to alter on this code?

Please Login or Register  to view this content.

[romperstomper]

You need to make your criteria values lower case since you use LCase in the code...

[Colin Smit]

You need to make your criteria values lower case since you use LCase in the code...

LOL.... Did not even pick that up. Silly mistake on my part.

Thank you for all the help. Even though you did not understand 100% the question I had, You still managed to solve it.
Thank you!

[Colin Smit]

Thread will now be marked as solved!

[Colin Smit]

That's not my code. You are missing two End If lines there, or one and use ElseIf:

Please Login or Register  to view this content.

The code above now works perfect based on the "combobox1" and "Textbox_EmployeesAbsentYesNo" values. Would it be possible to add the 3rd combo box variable in above code that selects the form for the amount of employees absent? In other words the 3rd selection will only be activated if the answer to the "Textbox_EmployeesAbsentYesNo" is yes.

[romperstomper]

Yes - you can nest another If...Then clause inside the "yes" branch.

[Colin Smit]

Yes - you can nest another If...Then clause inside the "yes" branch.

It works...Tks!

I have however decided to combine the last to variables. See code below. The first selection will be for the specific area and the second one will be whether there are any individuals absent. That way I have solved the problem as well as reduced the amount of questions required to be answered. Saves time as well.

Please Login or Register  to view this content.

Again thank you for all the help!