List Box Clearing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank C - 13 Nov 2006 21:12 GMT

When a List Box Multiselect is set to 'None' I can reset the box with
me.Listbox = null.

When I try this with Multiselect set to 'Simple' , It doesn't clear the box.
How can I clear the entries in the box.

Thanks

Signature

Thank you

Frank C

Reply to this Message

fredg - 13 Nov 2006 21:28 GMT

> When a List Box Multiselect is set to 'None' I can reset the box with
> me.Listbox = null.
[quoted text clipped - 3 lines]
>
> Thanks

You can add a command button and use it's click event:

Dim varItem As Variant
For Each varItem In ListBoxName.ItemsSelected
ListBoxName.Selected(varItem) = False
Next varItem

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Frank C - 13 Nov 2006 21:59 GMT

Thanks Fred that worked great.
Frank

Signature

Thank you

Frank C

> > When a List Box Multiselect is set to 'None' I can reset the box with
> > me.Listbox = null.
[quoted text clipped - 10 lines]
> ListBoxName.Selected(varItem) = False
> Next varItem

Reply to this Message