Delete a ListBox using VBA

I am trying to delete the ListBox using VBA. But, I am not able to get it deleted. This is my Code,

Sub Del_FListBox()

Dim FListBox As ListBox

ThisWorkbook.Sheets("Home").FListBox.Delete

End Sub

Kindly share your thoughts.

Upvotes: 1

Views: 74

Answers (1)

Plagon
Plagon

Reputation: 3138

try:

Worksheets("Home").Shapes("List Box 1").delete

Upvotes: 2

Related Questions