Listbox

[ranswrt]

I would like to get a listbox on a worksheet that would would show a range of
cells but I don't need to select them. How do I do this? I would also like
to have the scroll bar on the right for when the list gets long.
Thanks

 

[Gord Dibben]

Simple ListBox from the Forms Toolbar with the Input Range set to your range of
cells.

With no cell link, selecting an item will do nothing.


Gord Dibben MS Excel MVP

 

[ranswrt]

Simple ListBox from the Forms Toolbar with the Input Range set to your range of
cells.

With no cell link, selecting an item will do nothing.


Gord Dibben MS Excel MVP

 

[ranswrt]

I've done that. I'd like it if nothing can be selected, just veiwed. Is
that possible?
Thanks

 

[Gord Dibben]

I don't know if you can set it to have nothing selectable but still be able to
scroll.

What would be the harm if users were able to select an item as long as nothing
occurs?

Hopefully someone will have an idea.


Gord Dibben MS Excel MVP