I have a listbox on a userform which I have been refreshing by unloading the
form then reloading. Is there an easier way to do this.

Me.ListBox1.Clear

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Greg B" wrote in message
...
I have a listbox on a userform which I have been refreshing by unloading
the form then reloading. Is there an easier way to do this.

Thanks Bob for your help

Greg

"Bob Phillips" wrote in message
...
Me.ListBox1.Clear

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Greg B" wrote in message
...
I have a listbox on a userform which I have been refreshing by unloading
the form then reloading. Is there an easier way to do this.