1 Attachment(s)
i want VBA to display values greater than or equal to the given number
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),AL-Test (20)" 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" or any other no. in the second box so that it will display the data along with the >=data(10) from B column.
Attaching the File for reference.
1 Attachment(s)
Hi Please help me with this
Quote:
Originally Posted by
p45cal
See attached.
As you scripted it is not coming for my this scenario..
Refer attachment
is there any other method so that i can apply it over my every possible aspect, can't we define any other methods for box2 only which can help to find all related search with similar or greater than the given value?
Please help