Userform1.Listbox.Clear

--
__________________________________
HTH

Bob

"johnrb7865" wrote in message
...
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