title: How to clear DropDown List within a With block in VBA?
body: <p>I have a With block that has a condition to see if a value exists in the drop down list. </p>
  
  <pre><code>   With wb.Sheets("BudgetLines").DropDowns("Drop Down 22")
  
      For Each c In refData.Range("G7:G" &amp; LastRow_RefData).Cells
  
      Set Findo = wb.Sheets("BudgetLines").Cells.Find(c.Value, LookIn:=xlValues, _
                          SearchOrder:=xlByRows, SearchDirection:=xlPrevious, _
                          MatchCase:=False, SearchFormat:=False)
  
  
  
  
  
  
      If Findo Is Nothing Then
                  Debug.Print "Name was not found."
  
                  'DropDowns("Drop Down 22").Clear
              Else
                 Debug.Print "Name found in :" &amp; Findo.Address
  
                  'Add title to drop down box
                  .AddItem c.Value
  
              End If
  
      Next
  
  
  End With
  </code></pre>
  
  <p>However, I want to clear the dropdown list completely. I have tried .Clear but it doesn't seem to pick up as this is in the With block.</p>
  
  <p>Is there a way to do this within the With block?</p>