Thread: Cell Select
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Melosi[_3_] Tom Melosi[_3_] is offline
external usenet poster
 
Posts: 3
Default Cell Select

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