+ Reply to Thread
Results 1 to 3 of 3

Userform Textbox Looking at range not comparing case sensitive

  1. #1
    Registered User
    Join Date
    12-31-2005
    Location
    Atkins, Arkansas
    MS-Off Ver
    2013
    Posts
    63

    Userform Textbox Looking at range not comparing case sensitive

    I have a text box that is looking at a range, Column A, if there is a match it lets you continue. If no match is found I have a message box that says no match. I need it to be case sensitive but it is not for some reason. Is there something I can add to make it an exact match?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,552

    Re: Userform Textbox Looking at range not comparing case sensitive

    One way
    Please Login or Register  to view this content.
    However Match entire column takes time, so better narrow the range.

    Or maybe Find method with MatchCase set to True.

  3. #3
    Registered User
    Join Date
    12-31-2005
    Location
    Atkins, Arkansas
    MS-Off Ver
    2013
    Posts
    63

    Re: Userform Textbox Looking at range not comparing case sensitive

    Works good. Thanks for quick reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Case-Sensitive Conditional Formatting (in range)
    By ykobure in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2015, 12:38 PM
  2. [SOLVED] Sum a range containing 3 text Characters then a number but not case sensitive
    By chrisandsally in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-06-2015, 02:42 PM
  3. [SOLVED] userform textbox - comparing value to workheet cell value %
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2014, 02:22 PM
  4. [SOLVED] SUMPRODUCT Or SUMIF - In case of Case sensitive???
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-28-2012, 07:57 AM
  5. Replies: 4
    Last Post: 06-19-2011, 03:07 AM
  6. Counting case-sensitive values withon a range of cells
    By Jessika in forum Excel General
    Replies: 2
    Last Post: 02-13-2007, 04:28 PM
  7. .Name case sensitive
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 05:00 PM

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