Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Refreshed ListBox (XL97:SR2)

    I'm having difficulty in what appears to be refreshing a listbox. I have tried to use Listbox1.repaint but that does not work. The XL file that I've been using is attached.

    Thanks,
    John
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Refreshed ListBox (XL97:SR2)

    Try adding this:
    <pre>ListBox1.RowSource = "myrange"
    </pre>

    in the commandbutton1_click event
    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •