| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Listbox does not support saving | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
| Saving listbox values to a sheet then repopulate | Excel Programming | |||
Linear Mode
