i want VBA to display values greater than given number
Please help me to solve the problem, i tried to create 2 text box from ActiveX control, where first box will search given text value for me from the range, and i want to put a certain no to my 2nd text box which required to concatenate with the first text boxes value and will display me the data equal or greater than the value provide in the 2nd box.
In Sheet1, D column is having my data like - "Gold (5),Gold (20),Gold (15), Silver (10),Silver (15)" etc. all numeric values are in ().
in first text box i put the criteria for filter =textbox1.value & "*" for related search Now can any one help me what to do or how to code the second box so that if i put "10" in the second box along with the first box value as "Gold" it display data for >=Gold (10) from D column.
Its Urgent, in case any question please call me on 7618788845