Directed Listbox Population

I have a Listbox that gets populated by a code which gets all the worksheet names in the workbook and puts in the Listbox. The code has entries to skip some sheets so they do not get put in the Listbox. Of what gets put in the listbox, they're in alphabetical order. I'd rather direct which pages are at the top of the list. The last two characters prior to a "-" is how I would need to choose the population algorithm. AAAAAATB-BBBBBBWT. I would say all of the TBs get populated first, followed by the WTs, then the KOs etc, and then anything else gets populated.

Please Login or Register  to view this content.

I built a small workbook. It has to look at the two characters before the dash. It needs to be dynamic as there's a dozen different names I didn't include. I don't know how to approach it, some kind of weighting system? 1-5, and the WTs are assigned to the 1 case, and TBs to the 2 case? I don't even know, it sounds complicated.

Index
Matters Not bottom of list
Doesnt Matter bottom of list
xxxxxxCX-xxxxxx61 After TB
xxxxxxTB-xxxxxxWT second in lst
xxxxxxTB-xxxxxxKO second in lst
xxxxxxTB-xxxxxxAO second in lst
xxxxxxWT-xxxxxxKO top of list
xxxxxxWT-xxxxxxAV top of list
xxxxxxAV-xxxxxx61 after TB

That doesn't sound very fun Joli. I'd rather find a programatical solution just for the knowledge of how to do it.

Can you code it that it excludes the Worksheet names ending with MAP?

Please Login or Register  to view this content.

I list sheets here that I do not want added into the Listbox right? Other than the MAP ending, I would like to programatically exclude the MAP worksheets, as there's a lot of them.

Please Login or Register  to view this content.

That didn't seem to work, the Map sheets are in the listbox. this is what a Map sheet looks like: xxxxxxWT-xxxxxxAV MAP

Please Login or Register  to view this content.

I can't seem to figure out where to put this in the above code. I keep getting end if without block if. Thanks for the help with the case statement, it works great.

Please Login or Register  to view this content.

considering this post is solved, I'll create a new post. but, the Map sheets get called by a control in their parent sheets, so they do not need to be in the listbox (Solved), or visible in the workbook until called.