+ Reply to Thread
Results 1 to 2 of 2

Mismatch error when comparing cell value with textbox value

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Aberdeen
    MS-Off Ver
    Excel 2016
    Posts
    60

    Mismatch error when comparing cell value with textbox value

    Hi all, i try to create a type of search machine. I write in a textbox named Textbox1 and the value i type is real time compared to a range of values of another sheet. Also at the same time while i type, the matching results returned are added to another textbox called TextBoxGroups. However when i do that i have mismatch error and i cannot figure out why..
    Any help appreciated
    Thank you.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Mismatch error when comparing cell value with textbox value

    Sheetname needs to be between double quotes.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. [SOLVED] Overcoming runtime error Type13 mismatch with #N/A in cell
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2018, 06:38 AM
  2. Run-time error ‘13’: Type mismatch on Userform textbox if empty
    By dentler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2017, 03:37 AM
  3. Type Mismatch Error for writing text in a cell
    By PleaseHelpMe3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2016, 06:29 PM
  4. [SOLVED] Type mismatch error obtaining value from a cell
    By ssu95bm in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2015, 09:30 AM
  5. [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
  6. [SOLVED] Run-time error '13': Type mismatch - How to work with Cell.value
    By beutlerm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2014, 01:18 PM
  7. Type Mismatch Error when deleting a cell
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2008, 01:07 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