Delete a ListBox using VBA

Question

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.

Plagon · Accepted Answer · 2017-05-25 11:24:21Z

2

try:

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

answered May 25, 2017 at 11:24

Plagon

3,1651 gold badge14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1