• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to compare value against a range & return result

N

New VBA User

New Member
I have a user who selects value from drop-down. That value should be compared against the values in master sheet.

A B C
X 60 160 480

So when a user selects 60 from drop-down it should check the value in the range if greater than or equal to - in this case it should return all A, B & C. if user selects 160 then it should return B & C
 
Hi, New VBA User!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!
 
You must log in or register to reply here.
Back
Top