How to Clear a Drop-Down selection whit a button

[Capy_Uther]

Hello to everyone on my excel im using a button to clear cells everytime i click it:

Sub BorrarTodo()

x = MsgBox("Se borrará todo el contenido de esta cotización", vbYesNo, "Eliminar Fila")

If x = vbYes Then
Range("G5").ClearContents
Range("A18:C44").ClearContents
Range("G4").Value = Range("G4") + 1

End If
End Sub

But on cells E18 to E44 are all drop down options, rite now when anything is selected on any of those drop downs manualy i go 1 by 1 and click the 1st option on the drop-down menu to make them blank again

Is there a way to use the same Clear button for reset to blank E18 to E44 cells ?

 

[Joe4]

Is that "blank" option at the top of your drop-down list REALLY empty, or is it something like a single space?

So, if you chose the blank option for cell E18, and then entered this formula in any blank cell, what does it return?

=LEN(E18)

 

[Capy_Uther]

Is that "blank" option at the top of your drop-down list REALLY empty, or is it something like a single space?

So, if you chose the blank option for cell E18, and then entered this formula in any blank cell, what does it return?

=LEN(E18)

Its a blank Cell but if we need i can add an space if its needed for the solution

if i put that command on a cell with E18 selected blank option it drops a number "0"

 

[Joe4]

I did some testing, it and it appears that you should be able to use the same logic you already used on your other range:

Range("E18:E44").ClearContents