Userform Listbox - Disable Selection (but enable ScrollBar)

**jamesryan** · 04-15-2010, 05:13 AM

Hi,

I have a userform which brings up a listbox containing a number of rows (variable from 0 - 60 depending on other parameters.

I want the user to be able to see the rows of the listbox, and be able to use the scrollbar so they can see all of the list, however NOT to be able to select an item.

The reason is that it is just simply a list for show, and is not used for any further analysis.

Is this possible?

Cheers

J

**romperstomper** · 04-15-2010, 06:59 AM

Why does it matter if they select an item? You don't have to do anything with the selection.

**superj707** · 05-26-2016, 06:04 PM

It matters because allowing them to select something makes it appear as though the app is going to do something with the data. It's confusing. I came here hoping for an answer to this exact problem the OP posted. Sad that I can't find an answer anywhere.