VBA question: acListBox

[Xipooo]

I think the OP is talking about a combo box control. ItemsSelected is not in scope. Also, the For Each ctl in statement should set ctl =

Afraid you got it mixed up my friend. He is using a Listbox. His ComboBoxes are clearing fine according to his original post.



Rather than doing a loop through all the selected values, if he just changes the collection to a null or nothing it should clear out the selected values for him. Much easier IMO.

[DB88]

ItsMe,

My code above that clears the ComboBox is working fine. I need help adding a ListBox clear

[DB88]

Xipooo,
I don't want to clear the ListBox rowsource. Hence me telling you that your suggestion of ctl.RowSource="" does not work and that RowSource is not the way to go.

I attempted your suggestion of Set ctl.ItemsSelected=Null and get a compile error "Invalid Use of Property". Maybe ItemsSelected is not the appropriate property either. Like I said I'm very new to VBA (like 2 hours), so I'm trying to figure out what ListBox property is responsible for holding a user selection. Once we have that, clearing it should be easy.

[Xipooo]

Here, just do this...

http://allenbrowne.com/func-12.html

[DB88]

That will work, thanks!

[ItsMe]

Afraid you got it mixed up my friend. He is using a Listbox. His ComboBoxes are clearing fine according to his original post.
...

OK, I was not tracking. Thought the whole thing was around a combo.