+ Reply to Thread
Results 1 to 4 of 4

Matching Number in TextBox

  1. #1
    Registered User
    Join Date
    11-09-2020
    Location
    Malaysia
    MS-Off Ver
    365
    Posts
    11

    Lightbulb Matching Number in TextBox

    Hello Excel Users,

    I come with a request. Hope all are doing fine.
    So I have 1 textbox to type in numbers etc. 12345 (it will always be 5 digits).
    It will have to match with the same number in the same colunm B.
    After matching, textbox 2 will show me it match 1 time.
    Then textbox.1 immediately gets cleared and I typed in the same number 12345 again.
    Could you help me make textbox 2 show me 2?

    I dunno how to begin with the code But have attached the file for a clearer picture.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Matching Number in TextBox

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will provide the link for you this time: https://www.mrexcel.com/board/thread...xtbox.1150618/)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-09-2020
    Location
    Malaysia
    MS-Off Ver
    365
    Posts
    11

    Re: Matching Number in TextBox

    Oh okay I am so sorry. I overlooked the cross linked forum rule. Will you all still help me? Or maybe delete this thread. Will definetely not commit this mistake again

  4. #4
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Matching Number in TextBox

    if I read correctly
    Please Login or Register  to view this content.
    put code in your userform module, type in number and press enter
    Last edited by nigelog; 11-09-2020 at 01:14 PM.

+ 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. How copy Textbox under matching cell?
    By Frigide in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2019, 10:08 AM
  2. Using a Textbox to find row number to populate data into that row by indicated cell number
    By SteynfaardtD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2019, 02:14 AM
  3. find textbox value in sheets and put all matching criteria in a listbox
    By edwinsihaloho in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-01-2014, 05:28 AM
  4. find textbox value in sheets and put all matching criteria in a listbox
    By edwinsihaloho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2014, 12:37 AM
  5. [SOLVED] Enter a number in a Textbox then find the number in a cell to activate Hyperlink
    By lapot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2014, 10:26 AM
  6. [SOLVED] Trouble with getting a checkbox to place a cell value when matching the textbox.
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2014, 02:57 PM
  7. [SOLVED] Highlight matching string in Listbox based on Textbox value
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2014, 11:04 AM

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