Re: Form 'Refresh' problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David (dturner4_1999_at_yahoo.com)
Date: 05/22/04 

Date: Sat, 22 May 2004 04:17:49 -0700

Stuart wrote

> If I immediately run the routine again, then the first
> listbox is empty of text. If I restart Excel, then the form
> displays correctly, but again, just for the first time.

Just a guess, since no code is posted, but if you currently use Userform1
_Initialize to set the listbox text, try Userform1_Activate instead. 

-- 
David

Relevant Pages

  • Re: Any way to have a ListBox with nothing selected?
    ... Hi, just wondering how to add an empty item at position 0 after data binding as I have a listbox that is currently setup with a databind, after using a stored procedure to fill a dataset? ... "John Timney (Microsoft MVP)" wrote: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Clear all items from a list box control
    ... or unselect any selected entries? ... just set the RowSource to an empty string: ... How can I clear ALL entries in a ListBox control on a form? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem with Listbox having dynamic content with a minimum width
    ... one for empty and one for data. ... listbox and the second column contains some buttons. ... expand to show all the content. ... included the css class used for the listbox. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Iterating through an enumeration?
    ... If you're worried about the code being as concise as possible you can use: ... Assuming the listbox is empty, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ASP.NET
    ... My second problem is with the ListBox. ... >> The DataSource In the property of the ListBox, ... dataadapter and dataset at design time. ... But even if the dropdown list in the property box IS empty, ...
    (microsoft.public.vsnet.general)