Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox ?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |