Hello all and Happy Holidays.
I know my problem is probably simple and staring me right in the face, but I cannot find it.
I have this Data Validation formula in H14 =G14="Not Listed"
It is simple and straight forward. It insures that no user can enter a value in H14 unless The value in G14 is "Not Listed"
I now need to create a formula for L14. However I need it to work for L14 with three different values that come from K14. The values in K14 can only be: "Sec." , "Min." , or "Min:Sec".
These values come from either VBA code or an activex ComboBox choice.
The second problem is..... If a user removes any one of the stated values or selects the lone blank value from the ComboBox, Then I need the Value in L14 to be blank.
Both the validation formulas in columns H and L are in cells 10 thru 5000.
I would post all the failed formulas that I have tried, but that would take all day. (both to type and to read!)
Thank you in advance,
Jim
I know my problem is probably simple and staring me right in the face, but I cannot find it.
I have this Data Validation formula in H14 =G14="Not Listed"
It is simple and straight forward. It insures that no user can enter a value in H14 unless The value in G14 is "Not Listed"
I now need to create a formula for L14. However I need it to work for L14 with three different values that come from K14. The values in K14 can only be: "Sec." , "Min." , or "Min:Sec".
These values come from either VBA code or an activex ComboBox choice.
The second problem is..... If a user removes any one of the stated values or selects the lone blank value from the ComboBox, Then I need the Value in L14 to be blank.
Both the validation formulas in columns H and L are in cells 10 thru 5000.
I would post all the failed formulas that I have tried, but that would take all day. (both to type and to read!)
Thank you in advance,
Jim