On my spreadsheet I want to put a list of items in a box that will have a
scroll bar for when the list is longer than the box. I don't want to be able
toselect any of the items, just veiw them. How do I do this?
Thanks

You can use a listbox without any event code. Either load it with the
AddItem method or use the ListFillRange in the properties window. Without
the event code the list box will just sit on the sheet untill you enter
design mode and delete it.

"ranswrt" wrote:

On my spreadsheet I want to put a list of items in a box that will have a
scroll bar for when the list is longer than the box. I don't want to be able
toselect any of the items, just veiw them. How do I do this?
Thanks

Thanks I'll try that.



"JLGWhiz" wrote:

You can use a listbox without any event code. Either load it with the
AddItem method or use the ListFillRange in the properties window. Without
the event code the list box will just sit on the sheet untill you enter
design mode and delete it.

"ranswrt" wrote:

On my spreadsheet I want to put a list of items in a box that will have a
scroll bar for when the list is longer than the box. I don't want to be able
toselect any of the items, just veiw them. How do I do this?
Thanks