I'm having trouble trying to open a specific worksheet that is selected from a dropdown list. The goal is to select one of the 32 options from the dropdown list and have excel show me only that worksheet. The issue with the code I currently have is that its not showing the selected worksheet because the name of the different options in the dropdown list are too long. I guess the solution would be to create a VBA code that reads the initial number of the string and then show that specific worksheet. For example: If I select "1.8 Citizen petitioner One Step Child" from the drop down list, have excel only read the initial number (as string) and only show that worksheet name, which would be worksheet named: 1.8.
I have attached the workbook to better understand what I'm trying to explain.
Thanks in advance for any help in this matter!!
Please Login or Register to view this content.