ExcelBanter - Clear the INDIRECT drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Clear the INDIRECT drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/266042-clear-indirect-drop-down-list.html)

rmcdonald76

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.

wickedchew

Quote:

Originally Posted by rmcdonald76 (Post 959649)

Nope.

But I think that can be achieved by using FORMs and a little VBA code.

All times are GMT +1. The time now is 11:21 PM.