Refreshing the values in a ListBox

Question

JSL gurus,

Is there a way to refresh the values of a ListBox? Or perhaps clear all of the current values so that I can append new values? Below is a simple example where my initial list is unsorted but if the button is clicked, the values will appear in sorted order.

Thanks,
Wayne

Sorry for the formatting, first time posting.

djhanson · Answer

Stupid me!  I had placed the code in my ListBox2 :) .  The code worked perfectly when placed in ListBox1 (my first listbox).  In my case ListBox2 depends on ListBox1 entry.  It works great!

djhanson · Answer

This is sort of what I think I need to make a conditional listbox.  But it doesn't quite work.  The problem is that when I try to select an item it doesn't allow me to (only flashes the selected element gray in the listbox.  Any ideas of what might allow me to select an item after implementing this code?

unknown · Answer

That worked like a charm, Peter. Thanks for your assistance.