If then else statement for a combo box

Can someone take a look at this code attached

I added a combo box called (combobox2) for the user to be able to choose either Tops or Bottoms for a uniform issue or return. The code works as long as tops are selected, but will crap out on bottoms and I changed the cell reference(in Red) in the code to the bottoms area of the worksheet and it did not work. Why?

Here is the code and I will attach the worksheet as well. Any help will be appreciated.

Thanks,

LeapingLizards

Please Login or Register  to view this content.

If I change the code to read Bottoms it will not work. Thanks Solus! If you test it out it will not work??? Suggestions?

Thanks,

LeapingLizards

Will give it try. Thanks Solus! Enjoy your holiday. I will repost if it fails to work thank you!

LeapingLizards

Works Awesome! Nicely done! Enjoy your Holiday Solus!