View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default BEFORE SheetSelectionChange

Thanks for taking the time to read my question.

I'm using Excel 2003 and I want to capture changes to a cell's value. How do
I know with VBA that a cells value has changed / updated?

I tried SheetSelectionChange, but it only gives me the value of the new cell.

Basically what I'm trying to do is if a cells value has gone from "" to
anything, lock the cell so it can't be edited.

Thanks,

Brad