T
Tom Melosi
Is there a way to determine if a cell is selected? I tried to use the
onchange event, but that only works when something is changed. If a certain
cell is selected, I would like to test and make sure another cell has data
in it.
For example, the user must choose a value from a data validation drop down
list in cell C7 before the cascading list in cell D8 is populated. If they
try to select cell D8 first, I want to display a message and then set cell
C7 as the active cell.
I'm not sure if there is a way to capture a cell select versus a change???
Thanks,
Tom
onchange event, but that only works when something is changed. If a certain
cell is selected, I would like to test and make sure another cell has data
in it.
For example, the user must choose a value from a data validation drop down
list in cell C7 before the cascading list in cell D8 is populated. If they
try to select cell D8 first, I want to display a message and then set cell
C7 as the active cell.
I'm not sure if there is a way to capture a cell select versus a change???
Thanks,
Tom