How to visually unselect an item in a single selection ListBox?

[pharmacologist]

I am using the first listitem in a ListBox to serve as a header row in a multicolumn ListBox but I can't seem to visually unselect it when the user selects it (since it's not actually an item I want to be selectable).

I have the change event set to this (have attempted multiple ways to unselect as you can see)

Please Login or Register  to view this content.

The ingredientsbox.ListIndex correctly changes but the row is still visibly selected. Is there a way to make the selection visually go away? Thanks

[torachan]

your code does not tell us what method you are using to load your listbox.
put your header names in a label above the listbox.
otherwise if listbox.listindex =0 then exit sub

[pharmacologist]

Items are added like this through a loop:

ingredientsList.AddItem
ingredientsList.List(ingredientsList.ListCount - 1, columnNumber) = valueStr

Headers are added at the end the same way with index of 0.

[torachan]

attached file is a demo of userform with listbox with headers.
rowsource loading is the only method that supports the use of headers.
however it is the least stable (if you use the 'rowsource' within the properties section)
by the far better way is to use the .list method and load from a table via an array and put a label containing your headers over the top of the listbox.
the .additem is really intended for loading just individual items, it is an inefficient way of loading multiple items.