Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected

Hi

you need a simple macro.

Change your definitions for Operations, Office and Maintenance to include row 2.
You will need to go to formulas and select name manager.

right click on your sheet name at the bottom of excel and select view code.

Paste this code in the new window and close it.

Thats it.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$16" Then

Range("O16").Value = ""
End If

End Sub

Hi Mehmetcik,

You are a champ Thank you so much ... it worked

Thank you so much for your quick response.