+ Reply to Thread
Results 1 to 1 of 1

VBA listbox based on value in textbox

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Dordrecht, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    31

    VBA listbox based on value in textbox

    Dear excel users,

    I'm facing a problem. I have a userform 1 textbox and 1 listbox.

    I've created a code that the textbox can only contain numbers as i want it.

    In the excel sheet i've a sheet called "Stinger2sort" with data in A1 to A7 so far.
    This is variable since i've a ''save'' button elsewhere which allows me to add data to the list!

    example of data so far:
    A1 = 80Moriginal
    A2 = 70Mtest
    A3 = 90Mtest
    A4 = 90M80details
    A6 = 80MV2
    A7 = 80Mv3
    etc

    What i would like to have is the following:

    In textbox "Radius" i enter the value "80"
    Now i want that listbox "Radius2" shows all the names containing the value 80.

    After this i will select a name i want.
    When hitting the ''ok'' button, it has to search the selected name in a range of data in another sheet.(i can fix this i guess)

    Regards,

    Erwin
    Attached Images Attached Images

+ Reply to 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