lock listbox items
 

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

lock listbox items
 

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?

lock listbox items
 

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?

lock listbox items
 

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?