Hello
i searched for the answer on the forum but could not find a solution that worked for me.
Problem: i have a log of calls and would like to limit some columns to either "yes" or "no" and if the cell is left blank to default to "no".
originaly i set up a validating rule with the list: Yes, No; and UNTICKED "ignore blank". however nothing happens if i tab through the cell in question. i only get an error if i select one of the options from the pull-down list (Yes, No) and then delete it using backspace. if i delete it using "delete" key i dont get an error.
ideally i would like the cells to defaul to "No" if its left blank and only if there is something in column A.
i am reluctant to use macros/vba because:
a) its a large speadsheet and i dont want to weigh it down even more
b) dont have much experience in vba
i am using excel'02 sp1
i would very much appreciate any help/advice
thank you
Lisa
i searched for the answer on the forum but could not find a solution that worked for me.
Problem: i have a log of calls and would like to limit some columns to either "yes" or "no" and if the cell is left blank to default to "no".
originaly i set up a validating rule with the list: Yes, No; and UNTICKED "ignore blank". however nothing happens if i tab through the cell in question. i only get an error if i select one of the options from the pull-down list (Yes, No) and then delete it using backspace. if i delete it using "delete" key i dont get an error.
ideally i would like the cells to defaul to "No" if its left blank and only if there is something in column A.
i am reluctant to use macros/vba because:
a) its a large speadsheet and i dont want to weigh it down even more
b) dont have much experience in vba
i am using excel'02 sp1
i would very much appreciate any help/advice
thank you
Lisa