Thread: Type into one cell and automatically clear contents in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bo Bo is offline
external usenet poster
  
Posts: 2
Default Type into one cell and automatically clear contents in another cell
Is there a way to type information into a cell and have visual basic
clear the contents in another cell without clicking on a button etc?

cell A1 cell B1
..595 .42 (.42 would be deleted by typing .595 in cell A1)

Or the contents in cell A1 would be deleted if Cell B1 value changes
or is greater than 0.
Reply With QuoteReply With Quote