Michaels
Active Member
- Joined
- Apr 2, 2009
- Messages
- 404
Hello,
Long time I haven't posted, so happy to post a question
The project I'm currently working is has a userform with 6 listboxes and user can add items to those listboxes (the data goes to sheet 1 first and then displays on listbox for all 6 and those listboxes data can be added or edited by user. So when the user closes the file, and opens the file, he would see the data previously saved in worksheet ranges)
So the row source for all these listboxes is worksheet 1 ranges.
Is there a way to have those row source in memory or class, which can be saved and edited and later retrieved when user opens the excel file again, I simply don't want to use the worksheet or add item method to display the data in listboxes.
Thank you for your help.
Long time I haven't posted, so happy to post a question
The project I'm currently working is has a userform with 6 listboxes and user can add items to those listboxes (the data goes to sheet 1 first and then displays on listbox for all 6 and those listboxes data can be added or edited by user. So when the user closes the file, and opens the file, he would see the data previously saved in worksheet ranges)
So the row source for all these listboxes is worksheet 1 ranges.
Is there a way to have those row source in memory or class, which can be saved and edited and later retrieved when user opens the excel file again, I simply don't want to use the worksheet or add item method to display the data in listboxes.
Thank you for your help.
