Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Question Clear the INDIRECT drop down list

I have created an INDIRECT drop down list in cell B dependent upon cell A. Is there a function I can use to that will automatically clear the selection in cell B when cell A is changed? Hope that's clear.
  #2   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by rmcdonald76 View Post
I have created an INDIRECT drop down list in cell B dependent upon cell A. Is there a function I can use to that will automatically clear the selection in cell B when cell A is changed? Hope that's clear.
Nope.

But I think that can be achieved by using FORMs and a little VBA code.
__________________
Asobi Wa Owari Da
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Clear Previous Selection From a Drop Down The Griffster Excel Discussion (Misc queries) 3 September 22nd 10 09:36 PM
Can I clear UNDO list? Duke Excel Worksheet Functions 1 March 2nd 09 06:01 PM
Validation - clear blanks from drop down Hayley Excel Worksheet Functions 13 July 1st 07 10:19 PM
Macro to clear contents of unprotected cells AND drop down boxes JB2010 Excel Discussion (Misc queries) 3 March 30th 06 10:13 AM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"