listbox saving ?

[Guest]

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]

How about saving it into another worksheet (hidden??)

 

[Guest]

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 ?

 

[Guest]

Thanks, I think I figured

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 ?

 

[Tom Ogilvy]

Me.ListBox1.RowSource = r.Address(external:=True)

 

[Guest]

Thanks, this is better

Me.ListBox1.RowSource = r.Address(external:=True)