Userform ListBox that recalls prior selections made

**skysurfer** · 08-05-2010, 01:31 PM

Hi,

Is it possible to have a Userform containing a multi select ListBox open with the same items selected/highlighted from the last time the UserForm was opened and ListBox selections made?

I have a ListBox on a UserForm that reads from a dynamic range and outputs to a dynamic range and I would like the ListBox to be repopulated with the selections made the last time the UserForm was opened.

Lawrence

**royUK** · 08-05-2010, 02:09 PM

The Userform will retain the selections if you Hide it as opposed to Close it.

If you want to retain the selections for another session then you must save the selections to a hidden sheet, the registry, ini file or text file. Then read the selections back into the Userform when it is loaded again

**skysurfer** · 08-05-2010, 02:13 PM

royUK,

If I have the selection stored in Range("selectedstuff") on Sheet11, what is the code to have the list box read that range as the highlighted selections when the file and form are reopened?

Thanks!

Lawrence

**skysurfer** · 08-05-2010, 06:42 PM

Just bumping this up the list...

:-)

**skysurfer** · 08-08-2010, 02:54 PM

Thanks to Leith Ross (and two days of searching the forum to locate his elegant solution), here it is:

Please Login or Register  to view this content.

And Leith's original post is here: http://tinyurl.com/22ozfzr

THANKS LEITH!

Lawrence

Userform ListBox that recalls prior selections made

LinkBack

Thread Tools

Rate This Thread

Display

Userform ListBox that recalls prior selections made

Re: Userform ListBox that recalls prior selections made

Re: Userform ListBox that recalls prior selections made

Re: Userform ListBox that recalls prior selections made

Re: Userform ListBox that recalls prior selections made

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions