Listbox
 

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

Listbox
 

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

Listbox
 

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