What is the syntax to clear a listbox?

<listbox name>.Clear

'if clearing a userform's listbox from outside the userform
<userform name>.<listbox name>.Clear
'example
formHome.lstOutput.Clear

 

What is the syntax to clear a filter but leave drop-down icons?

Sheets("<sheet name>").ShowAllData
'examples
Sheets("RevenueSummary").ShowAllData
ActiveSheet.ShowAllData

For another version of clear filter that does remove the filter drop-down icons, click here.

What is the syntax to clear an autofilter?

Sheets("<sheet name>").Range("<chart cell>").AutoFilter
'where chart cell is the right-most, top-most cell containing filtered data
'clears the filter dropdown icons as well
'example
Sheets("RevenueSummary").Range("A1").AutoFilter

For another version of clear filter that doesn’t remove the filter drop-down icons, click here.

 

What is the syntax to clear a range?

'To clear all contents, including styling
Range(“<your range>”).Clear

'To clear only text
Range(“<your range>”).ClearContents
'examples
Range(“D:D”).Clear ‘clears column D
Range(“A2:C5”).Clear ‘clears range A2:C5
Range(“B1:B3”, “D1:E5”).Clear ‘clears multiple ranges
Sheets("Input").Range("pasteRange").ClearContents 'clears text only