Results 1 to 10 of 10

Thread: i want VBA to display values greater than or equal to the given number

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jun 2019
    Posts
    21
    Location

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •