problem clearing a selectbox in VBA.
Posted on 2007-03-30
Function ClearList(lst) As Boolean
Dim varItem As Variant
For Each varItem In .ItemsSelected
varItem.Selected = False
ClearList = True
I want to use the above function to clear the selections made in a selectbox.
However, I get the following error:
(message was in dutch, so I translated).
I used the correct reference to the object while calling the function:
I have a `sister`-function that will get the selected items and convert that to a string that can be used in a where-condition. That one works just fine.
What am I doing wrong??