Otlk 2k3 Script: Saving Listbox

  • Thread starter Thread starter news.microsoft.com
  • Start date Start date
N

news.microsoft.com

Hi All,

I've added to my form a list box (5 columns) but the contents is not saved
is there a way to save it

Tks
 
You either have to save control contents yourself in code or bind that
control to a user property. But that won't work with a 5-column listbox.
That would have to be saved in code.
 
Hi Ken,

What about to save datas in Excel Sheet and load them each time the form is
opened, but the pb is when the form is used by more than one user in the
same time..... is there a way to bloc the access to excel and send a
message "Actually used by [mapi(username)] ???

Or save the content in 5 listbox and load them to my LISTBOX at the
openning of the form ???

or have U an other idéa ?

Other question:
How can I fill the Headers of the list Box I look VBA help but didn't
found .

Tks a lot
 
You would have to work out your own interlock mechanism and implement it.
There's nothing built-in for that. You could also just extract the data and
place it in multiple UserProperty objects.

I've always found multi-column listboxes buggy so I don't work with them
from MS Forms 2.0 controls.

I believe you would have to use the first row as the column headers and set
the Boolean ColumnnHeads property. The Help for all the MS Forms 2.0
controls is in the Object Browser for the MSForms library. That's what's
used in Outlook forms.
 
It's actually simpler than that: ColumnHeads are not supported at all on custom Outlook forms.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
There you go, one more reason not to use custom forms <g>




It's actually simpler than that: ColumnHeads are not supported at all on
custom Outlook forms.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Damn, My listbos was so nice.....

Il remake it using the built in Note (task) it not to nice but I can keep
it saved, and I have to calculate the len of each word to know the number
of VbTab to insert in order to look like a tab.....

Tks
 
Back
Top