Thanks, I think I figured
"pm" wrote:
I just wondered if theres are any other ways. Now I did try this with
worksheet range
Set r = ActiveWorkbook.ActiveSheet.Range("A1:A30")
Me.ListBox1.RowSource = r
But that gives an error.I guess I'm not setting rowsource in right way ?
"Dave Peterson" wrote:
How about saving it into another worksheet (hidden??)
pm wrote:
Hi I created a listbox list by additem method. I like to be able to save this
list when user clicks on a Button and access next time they open the form.
But there seems to no method to save items into list. Any one knows a way?
Thanks
--
Dave Peterson