Thread: [Solved] macro for change content of cell2 when content of cell1 changes
View Single Post
 
Old 11-16-2012, 07:24 AM
Intruder Intruder is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Dec 2010
Posts: 59
Intruder is on a distinguished road
Default macro for change content of cell2 when content of cell1 changes
I have a sheet where content of cell A1 and B1 can be selected based on named lists. List of cell B1 depends on selection of content of Cell1.
when a new selection is made in cell1, the original selection in cell2 remains.
How can I make the content of cell2 blank if content of cell1 changes, or better when cell1 is selected ?
regards
roland
Last edited by macropod; 11-17-2012 at 08:22 PM. Reason: Fixed title reference
Reply With Quote