Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validating 4 values programatically
Hi, Using XL 2000
My worksheet contains numerical values in Cols A, B, C & D. Cols E & F Contain Contact Names. There are over 100 rows of data In my userform, a user selects a numerical value in Combobox1 and combobox2 On a click event, I would like the following to execute:- The value selected in CB1 is checked against every row and where it is greater than value in Col A AND less than the value in Col B, reports True The value selected in CB2 is checked against every row and where it is greater than value in Col C AND less than the value in Col D, reports True Only where 2 True's are present, I need the values in Cols e & F in the respective row that meets the true condition to be added to ListBox1. I hope i've manged to explain my problem. Any VBA ideas welcome. Thank you. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validating | Excel Discussion (Misc queries) | |||
Validating Values Within Sets of Groups in a Column | Excel Discussion (Misc queries) | |||
validating cells in the same row has unique values | Excel Worksheet Functions | |||
validating | Excel Worksheet Functions | |||
Validating | Excel Discussion (Misc queries) |