If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Listbox editing

Thread starter Flyingmeatball
Start date May 31, 2011

Flyingmeatball

Board Regular

May 31, 2011

I have a listbox that is popualted via VBA code, and some of the items in the list are already selected. I need to limit the ability of users to change the entity, but retain the ability to scroll. (I want people to see what has been selected, but not change it). If i set Listbox.locked = true, it no longer allows me to scroll. The listbox is enabled the entire time, and has multiselect set to 2 - fmmultiSelectExtended. I've searched the forums and can't come up with anything, the suggested solution of using .locked doesn't work in my excel 2007 version. Any thoughts?

Thanks!