Hi,

Try changing the forecolor to give a visual clue to the listbox's state.

If ListBox1.Enabled Then
ListBox1.ForeColor = SystemColorConstants.vbWindowText
Else
ListBox1.ForeColor = SystemColorConstants.vbGrayText
End If

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ExcelMonkey" wrote in message
...
I have a userform. I want to prohibit the user from one of the listboxes
at
certain times. I know I can set the .Enabled propterty = False. But how
to
you grey out the listbox?

Thanks

EM