Listbox non-updating/updating

[MattShoreson]

I would like to be able to change the way a listbox functions from allowing input, to not allowing input (but still being able to view previous selections).

I understand .enabled will achieve this but if it is set to false then the i am unable to scroll the list.

Any ideas/solutions?

tia Matt.

[royUK]

What kind of ListBox? On a UserForm, from the Forms ToolBar or Controls ToolBox?

[MattShoreson]

It's from the controls toolbox - the lists are placed directly on the worksheet.

(also, is there anyway of getting rid of the notice at the topas I've already read it - like an accept notice button or something along those lines?)

ta.

[royUK]

The notice is only temporary. It should go in a couple of days.

What input are you referring to, you cxan't type directly into a ListBox.

[MattShoreson]

normal listbox input - i.e. clicking an item in the listbox.

I've already created the listbox and populated it.
I want to hold the input so a user can use the current selection. (effectively non-updatable - but scrollable)
Then I want to 'switch modes' to updatable. (i.e. select more or less items (Updatable))

[royUK]

I'm not sure what you can do, you could try changing the Locked property, but how will you trigger any such change?

[Andy Pope]

Maybe this would work for you.

Userform with a listbox, commandbutton and label.
Click button to toggle 'lock' listbox selection.

You can select items when unlocked.
You can scroll list whether locked or not.

Please Login or Register  to view this content.