Sheerts("Home").ListBox1.ListIndex = -1

Will work with a Control Toolbox listbox but it does not go blank, it just
gives it a Null value. You can include a blank cell in your rowsource for
the first cell and use

Sheets("Home").ListBox1.ListIndex = 0

That will select the empty cell to display.

"ranswrt" wrote:

I tried what you suggested and got

Run-time error '424':
object required

I tried

Sheets("Home").OLEObjects("ListBox1").ListIndex = -1
'Home' is the sheet that contains 'ListBox1'

I got this error

Run-time error '438':
Object doesn't support this property or method.

I put the listbox in using the control toolbox. Any Ideas as to what I am
doing wrong?

"JLGWhiz" wrote:

If it is from the Control Toolbox and is single select:

Listbox1.ListIndex = -1

"ranswrt" wrote:

I have a listbox on a worksheet. When I leave the worksheet and go to
another worksheet or go to a userform from the worksheet and return back, how
do I make it so that none of the items in the listbox are selected?
Thanks