Closed Thread
Results 1 to 2 of 2

How Do I Make Case Sensitivity Not Matter?

  1. #1
    Registered User
    Join Date
    10-16-2011
    Location
    montana, usa
    MS-Off Ver
    Excel 2007
    Posts
    31

    How Do I Make Case Sensitivity Not Matter?

    So i have program that ask the user for an input. It then searches the entire active workbook for a sheet with the name from the userinput. If there is a sheet with that name, it makes that the active sheet. But if there is not a sheet with that same name it creates a new sheet named after the users input. So I have a sheet called "Capitals" and if a user enters "captials" into the userbox it tries to create a new sheet called "capitals" but then i get an error that says, you cant name a sheet the same name.

    here is my code

    Please Login or Register  to view this content.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: How Do I Make Case Sensitivity Not Matter?

    Hi Cfallscat
    One way would be to use the Ucase function
    Please Login or Register  to view this content.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1