VBA That looks for sheet name in a file and activates it

[Jstns]

Hi guys!

I have written some code that should allow the user to search a certain sheet that they are trying to find in a workbook that the macro opens. I am encountering one problem however, it does not work everytime I initiate it!

I tried it with inputting the value "F4" in the inputbox and it does go to the Using F4 sheet. When I try to type in statistics or sumifs and it tries to find the sheets called "Statistics" or "Sumifs & Countifs" it does not give back the sheet at all.

This is my code:

Please Login or Register  to view this content.

I hope I have written everything correctly and easy to understand. Please help!

[AlphaFrog]

The current code is case sensitive. This will make it case insensitive.

Please Login or Register  to view this content.

[Jstns]

Wow perfect! This is exactly what I need