View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mrlanier@hotmail.com is offline
external usenet poster
 
Posts: 63
Default When content of a cell changes, content of another deletes

If a formulated value in A1 changes to any value after a value is
manually entered in B1, I need the content of B1 to be deleted. In
other words, 1) A1 first reflects a formulated value, 2) a value is
manually entered into B1, 3) input elsewhere causes A1 to return a
different calculated value, 4) thus causing B1 to delete its input.
Is there a simple macro that will accomplish this? Thanks in advance.

Michael