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
Bookmarks