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

Maybe hiding it would work better.

ListBox1.Hide

If they can't see it they can't use it.
"ExcelMonkey" wrote:

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

Sorry, Hide is for the whole UserForm

ListBox1.Visible = False

Would hide the control.


"ExcelMonkey" wrote:

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

.... and maybe you could then display a label with the listbox value instead.

--
Tim Williams
Palo Alto, CA


"JLGWhiz" wrote in message ...
Sorry, Hide is for the whole UserForm

ListBox1.Visible = False

Would hide the control.


"ExcelMonkey" wrote:

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

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