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.
example:-
In Sheet1, B column is having my data like - "CORE JAVA (73),CORE JAVA (3),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" or any other no. in the second box so that it will display the data along with the >=data(10) from B column.
AL-Test (20)" etc. all numeric values are in ().
Attaching the File for reference.