Adding new sheet to existing userform

**darkangl640** · 02-25-2013, 10:00 AM

Hello!

Nickmax1 helped me out last week with some coding so my users had to choose between 2 combo boxes to go to the desired worksheet. I've attached the Test workbook he created. I had no problems adding "Construction MD" and Construction Repair", but I can't add "Exempt". I get a "run-time error 9" and "subcript out of range". If I click "Debug", it takes me to VBA and highlights
ThisWorkbook.Worksheets(strWS).Visible = True

I added my workbook with the hopes that you can figure out what I've done as I'm assuming it's something horribly wrong!! Any suggestions??

Thanks!!!!

**OllieB** · 02-25-2013, 10:12 AM

The worksheet that is selected when you click the button is determined by concatenating the values from the two combo boxes

Please Login or Register  to view this content.

You state you want to add Exempt, my question is: to which combo box?

Assuming combo box 1: then I would expect to see worksheets in your workbook with names 'Exempt DC', 'Exempt VA' and 'Exempt MD'. These worksheets do not exist hence the error message

**darkangl640** · 02-25-2013, 12:48 PM

Well, I want to add "Exempt" to combobox 1, and then a worksheet called "ALL" for combobox 2. Right now, they need to choose between "Repair" and "Construction", and I want to give them a third option, "Exempt". Then I want a totally different spreadsheet added that will not have taxes apply to anything. So I've been trying "Exempt" in Combobox 1 and "All" in Combobox 2, and I did create a spreadsheet called "All". Basically, all of the taxes will apply to a tax exempt customer, no matter the jurisdication, so I don't need DC, MD and VA choices.