Clear listbox

[johnrb7865]

Is there a way to clear the contents of a listbox when pushing the command
button to add the listbox contents to Excel?

Thanks,
John

 

[Bob Phillips]

Userform1.Listbox.Clear

 

[JLGWhiz]

Me.ListBox1.Clear

 

[johnrb7865]

Thanks Bob, that worked.

Userform1.Listbox.Clear

--
__________________________________
HTH

Bob