Clear Content on Dropdown List

[lesley burlingham]

I have the following code which hides and shows a dropdown box dependant on the value in a cell. I would like the drop down box to be cleared if the option is changed.

If Sheet8.Range("B3").Value = 2 Then

Sheet1.Shapes.Range("Drop Down 3281").Visible = msoTrue
Sheet1.Shapes.Range("Drop Down 3282").Visible = msoFalse
Sheet1.Range("Drop Down 3282").ClearContents
Else
Sheet1.Shapes.Range("Drop Down 3281").Visible = msoFalse
Sheet1.Range("Drop Down 3281").ClearContents
Sheet1.Shapes.Range("Drop Down 3282").Visible = msoTrue
End If

 

[jeffreyweir]

Hi Lesley. I take it you're using ActiveX dropdowns, but this may be of interest to you and possibly an easier option:
http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/
http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/

 

[NARAYANK991]

Hi Jeff ,

I think the usage of Drop Down 3281 and so on refers to Form Control Comboboxes.

Narayan