+ Reply to Thread
Results 1 to 5 of 5

Search a Textbox of a UserForm for a Value

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Search a Textbox of a UserForm for a Value

    Hi all,

    Wondering if there is a function that would allow me to search a textbox for a value. I want to set up some conditional procedures based on values entered into a textbox.

    Any help with this would be greatly appreciated!


    Wolfman

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Search a Textbox of a UserForm for a Value

    A simple approach would be something like this:

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Search a Textbox of a UserForm for a Value

    This is not specific enough. Need it to search for a specific value (ie contains the letter "E")

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Search a Textbox of a UserForm for a Value

    The answer was pretty much as specific as the question. You would have to explain what logic you need in the code to identify the string to search for. What I showed was the concept behind searching for a string in a text box, once you know what the string is. If you don't know how to write the code to specify the string to search for, I can help with that too if you explain how to identify the value. Is it always going to be the same value, no matter what? Or will it change depending on the situation? If you always always always search for "E" then the code is simply:

    Please Login or Register  to view this content.
    Otherwise I would need more details for what you need to do.

  5. #5
    Registered User
    Join Date
    06-28-2013
    Location
    London, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    69

    Re: Search a Textbox of a UserForm for a Value

    Quote Originally Posted by 6StringJazzer View Post
    The answer was pretty much as specific as the question. You would have to explain what logic you need in the code to identify the string to search for. What I showed was the concept behind searching for a string in a text box, once you know what the string is. If you don't know how to write the code to specify the string to search for, I can help with that too if you explain how to identify the value. Is it always going to be the same value, no matter what? Or will it change depending on the situation? If you always always always search for "E" then the code is simply:

    Please Login or Register  to view this content.
    Otherwise I would need more details for what you need to do.
    Yeah sorry about that I was in a bit of a rush when I responded/wrote the question. I will look at your posted code and get back to you here after the weekend. Thanks!

    Wolfman

+ 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. Userform to search textbox value to place other textbox values in worksheet
    By mattyh555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 11:38 AM
  2. search using textbox at userform
    By anthony_lrk89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2012, 11:06 PM
  3. Use Userform TextBox Entries to Search Worksheet
    By jasperhuang93 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2012, 09:16 AM
  4. [SOLVED] Add search function textbox in userform
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-23-2012, 01:47 PM
  5. Userform w/textbox search a table for a value on click
    By trader07 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-30-2011, 03:45 AM

Tags for this Thread

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