i want VBA to display values greater than given number (1 Viewer)

supraman

New member
Local time
Today, 06:45
Joined
Jun 13, 2019
Messages
1
HI,

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.

example:-

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
 

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 01:15
Joined
Jul 9, 2003
Messages
16,245
Is this an Excel question?

Sent from my Pixel 3a using Tapatalk
 

Gasman

Enthusiastic Amateur
Local time
Today, 01:15
Joined
Sep 21, 2011
Messages
14,048
You do realise that Gold (5) is greater than Gold (10) in your check?

Code:
? "Gold(5)" > "Gold(10)"
True
 

Users who are viewing this thread

Top Bottom