[CALC] Any way to clear a number of selection boxes at once? of

asked 2015-03-14 09:59:08 +0200

ChrisCrinkle gravatar image

I have a lot of drop down selection boxes which users can use. However, if possible, I need a button which will empty all selections at once (equivalent of pressing "del" with each of the cells selected). Is there any way to do this? If so please give links on how to learn (not youtube videos though, internet isnt good enough speed)

edit retag flag offensive close merge delete

Comments

Excuse me, what do you mean by "drop down selection boxes"? Does it Data - Validity with Criteria "Cell range" or "List"? Or it's control ListBox or ComboBox? The best solution for your problem will be the macro. But the macro code will be different for different types of "drop-down lists"

JohnSUN gravatar imageJohnSUN ( 2015-03-14 18:48:23 +0200 )edit