How to save ListBox Multiselect to Registry
Hello,
I have a multipage userform that has a dozen ListBoxes -- all with MultiSelect. I've saved the selections to a spreadsheet (1 row for each ListBox, each selection in adjacent columns).
However, when the User reopens the survey, the selections on the userform are all gone.
How can I save the selections to the Registry so that when the User reopens the userform, the ListBox selections show up?
Thanks in advance for your help.
You could read them from the spreadsheet in the Userform_Initialize procedure.
Example
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
You could store them as a customer property.
Each listbox name would be use to store a string of CSV for later use.
Each CSV would represent the selected value in the listbox.
If you had a list of ten in Listbox1 and 1,3 7 items are selected, this would generate a CSV like:
Listbox1,1,3,7
which you can parse later with the Split function.
Please Login or Register to view this content.
David
(*) Reputation points appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks