listbox saving ?
 

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

listbox saving ?
 

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

listbox saving ?
 

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

listbox saving ?
 

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

listbox saving ?
 

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

--
Regards,
Tom Ogilvy


"pm" wrote in message
...
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

listbox saving ?
 

Thanks, this is better

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"pm" wrote in message
...
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