|
|
#1
11-16-2012, 07:24 AM
|
|||
|
|||
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 
|
|
#2
11-17-2012, 08:24 PM
|
||||
|
||||
|
Hi Roland,
Your post suggests you're working with dependent dropdows, for which see: http://windowssecrets.com/forums/sho...474#post861474 http://www.eileenslounge.com/viewtopic.php?f=27&t=8830
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to link 2 content controls | bortonj88 | Word VBA | 2 | 08-21-2012 06:24 AM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
 Anybody know a macro that applies autocorrect to pasted content?
|
dennisk | Word VBA | 1 | 06-09-2011 12:26 AM |
| Macro to put content into keywords properties? | erik2000 | Word VBA | 3 | 03-05-2010 10:14 PM |
| Package for CD with links to Windows media player content and Flash Shockwave content | hectorh | PowerPoint | 4 | 10-15-2009 12:22 PM |
Windows XP 
Office 2007
Linear Mode
