From: JT on
Is it possible to prevent a user from selecting any item in a listbox? I'm
using a listbox to display the values of several cells. I just want the user
to be able to scroll through the list box and read what is there but not
select anything. is this possible?

Thanks for the help.
--
JT
From: JLGWhiz on
You can set the enabled property to False, if the list box is from the
control toolbox. However, if the user is Excel xavvy, they can change it
back to true. Maybe a textbox or a label would have been a better choice.



"JT" <JT(a)discussions.microsoft.com> wrote in message
news:59384919-5369-4B37-8CF3-B6CB407D49FA(a)microsoft.com...
> Is it possible to prevent a user from selecting any item in a listbox?
> I'm
> using a listbox to display the values of several cells. I just want the
> user
> to be able to scroll through the list box and read what is there but not
> select anything. is this possible?
>
> Thanks for the help.
> --
> JT