Is there a way of locking individual items in a listbox on a userform so as
they cannot be selected by the user?

AFAIK it's not possible.
Also, that would confuse the user; why give them the choice if they cannot
select it ?
Edit the list before you show it.

NickHK

"enyaw" wrote in message
...
Is there a way of locking individual items in a listbox on a userform so
as
they cannot be selected by the user?

The listbox I have is populated by items on a worksheet. The items cannot be
moved in the worksheet because they are being used in a data validation. I
have code that links the listbox to the worksheet so when the item is
selected in the listox it is also selected on the worksheet. I need to be
able to reference only some of the list on the worksheet for the listbox.
e.g. I need say A6:A10 and A12:A15.
Any ideas?

"NickHK" wrote:

AFAIK it's not possible.
Also, that would confuse the user; why give them the choice if they cannot
select it ?
Edit the list before you show it.

NickHK

"enyaw" wrote in message
...
Is there a way of locking individual items in a listbox on a userform so
as
they cannot be selected by the user?

Only add the valid items to the listbox, with .AddItem.

NickHK

"enyaw" wrote in message
...
The listbox I have is populated by items on a worksheet. The items cannot
be
moved in the worksheet because they are being used in a data validation.
I
have code that links the listbox to the worksheet so when the item is
selected in the listox it is also selected on the worksheet. I need to be
able to reference only some of the list on the worksheet for the listbox.
e.g. I need say A6:A10 and A12:A15.
Any ideas?

"NickHK" wrote:

AFAIK it's not possible.
Also, that would confuse the user; why give them the choice if they
cannot
select it ?
Edit the list before you show it.

NickHK

"enyaw" wrote in message
...
Is there a way of locking individual items in a listbox on a userform
so
as
they cannot be selected by the user?