PC Review


Reply
Thread Tools Rate Thread

Clear listbox

 
 
johnrb7865
Guest
Posts: n/a
 
      29th Jul 2008
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
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      29th Jul 2008
Userform1.Listbox.Clear

--
__________________________________
HTH

Bob

"johnrb7865" <(E-Mail Removed)> wrote in message
news39B3F26-0A25-4846-886C-(E-Mail Removed)...
> 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



 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      29th Jul 2008
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

 
Reply With Quote
 
johnrb7865
Guest
Posts: n/a
 
      29th Jul 2008
Thanks Bob, that worked.

"Bob Phillips" wrote:

> Userform1.Listbox.Clear
>
> --
> __________________________________
> HTH
>
> Bob
>
> "johnrb7865" <(E-Mail Removed)> wrote in message
> news39B3F26-0A25-4846-886C-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear Method not working for a ListBox clear scott56hannah Microsoft Excel Programming 4 14th Feb 2008 08:42 PM
Clear a listbox Erwin Bormans Microsoft Access 1 9th Jan 2008 10:12 PM
How to clear a listbox SF Microsoft Access 1 4th Apr 2006 09:42 AM
Re: dataset.clear doesn't clear listbox Val Mazur Microsoft ADO .NET 2 11th Nov 2004 03:12 AM
How can i clear a Listbox-Value with VB.net? Tom Microsoft Dot NET Compact Framework 1 28th Jul 2004 09:43 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:34 PM.