Clear listbox
 

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

Clear listbox
 

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

Clear listbox
 

Me.ListBox1.Clear

"johnrb7865" wrote:

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

Clear listbox
 

Thanks Bob, that worked.

"Bob Phillips" wrote:

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