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

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

On Thu, 3 Jul 2008 09:48:01 -0700, ranswrt
wrote:

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" wrote:

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

On Thu, 3 Jul 2008 09:48:01 -0700, ranswrt
wrote:

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

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

"Gord Dibben" wrote:

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

On Thu, 3 Jul 2008 09:48:01 -0700, ranswrt
wrote:

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

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


On Thu, 3 Jul 2008 14:22:02 -0700, ranswrt
wrote:

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

"Gord Dibben" wrote:

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

On Thu, 3 Jul 2008 09:48:01 -0700, ranswrt
wrote:

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