Clear All Dropdown Listindex

Hi,

I want to clear all contents of cells after completing macro for creating months. Range that needs to be cleared also contains dropdown shapes, which have code for inserting their values into cells under.

I want to set all dropdown Listindex-es to blank (-1), so that all cells in desired range would really be cleared.

Tried with this, but not working :

Please Login or Register  to view this content.

What am I doing wrong ?

See attached sample, and look at Clear_cells and Dropdown_Change macros !

Thanks for help in advance !

Hi Luka,

I'm glad you got the conditional format working.

Try the following to clear the list boxes (tested and working on my computer with your file):

Please Login or Register  to view this content.

Lewis

My original worked, but I misunderstood what you wanted. I thought you wanted the lists removed. What you really wanted was for each DropDown to be blank.

I tested the following on your sample workbook, and it seemed to be working, including December 1st.

Lewis

Please Login or Register  to view this content.

Much closer, but still someting wrong with this code.

It does clear all drop-downs, but cells in range still don't clear, not sure why as you made all code before Clear.Contents code

See this screenshot for February !

The .ClearContents line seemed to be causing a lot of problems. I replaced it with a line that sets to "" (NO VALUE) all cells that have 'Data Validation'.

Try this (changes from the previous version I posted are in red):

Please Login or Register  to view this content.

Hi LJMetzger,

I allready know that, and thanks to nilem on other thread I have solved this issue. A stupid mistake in this line was done by me:

Please Login or Register  to view this content.

A DOT was missing, now It works !!! Same goes for your code, thanks a lot !!!