Listbox ?

J

JT

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.
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top