I am new to VBA and trying to create forms that retain their values
between sessions without storing the userform data in a separate file.
The idea is to find a way to store the information in the .mpp file so
that when the file is passed to another user the form values remain.
Is this possible?

Thanks for the help,


Stephen

Hi,

It depends
Which values? How many?

You can always use the custom fields of the ProjectSummary Task, and Custom
File Properties.

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
<stephen.e.rich@intel.com> schreef in bericht
news:1142464188.779097.288620@e56g2000cwe.googlegroups.com...
> I am new to VBA and trying to create forms that retain their values
> between sessions without storing the userform data in a separate file.
> The idea is to find a way to store the information in the .mpp file so
> that when the file is passed to another user the form values remain.
> Is this possible?
>
> Thanks for the help,
>
>
> Stephen
>

Hi,

It depends
Which values? How many?

You can always use the custom fields of the ProjectSummary Task, and Custom
File Properties.

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
<stephen.e.rich@intel.com> schreef in bericht
news:1142464188.779097.288620@e56g2000cwe.googlegroups.com...
> I am new to VBA and trying to create forms that retain their values
> between sessions without storing the userform data in a separate file.
> The idea is to find a way to store the information in the .mpp file so
> that when the file is passed to another user the form values remain.
> Is this possible?
>
> Thanks for the help,
>
>
> Stephen
>

Nothing more than a dozen controls. How do I manipulate the two items
you suggested?


thanks for the help

Hi,

Activeproject.projectsummarytask.text22
"Text22" can of course be any of the custom fields
As for CustomDocumentProperties, that is a longer story and I have to refer
you to the help (readily available through the object browser in the Visual
Basic Editor).

Both processes I describe here only allow to store data (Text, Numbers,
dates..) but not objects such as controls themselves.

Hope this helps,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
<stephen.e.rich@intel.com> schreef in bericht
news:1142525197.423674.16600@j52g2000cwj.googlegroups.com...
> Nothing more than a dozen controls. How do I manipulate the two items
> you suggested?
>
>
> thanks for the help
>

Thanks, I can definitely look it up in help now that I know what to
search on. What would you suggest for storing objects if I need to in
the future. Just need a pointer on where to look. Thanks again for
your help.

Hi,

The form itself can be stored with the project
It is considered a module in the Organizezr so in Tools, Organizer, Modules,
move it into the file.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
<stephen.e.rich@intel.com> schreef in bericht
news:1142529353.381808.320260@j33g2000cwa.googlegroups.com...
> Thanks, I can definitely look it up in help now that I know what to
> search on. What would you suggest for storing objects if I need to in
> the future. Just need a pointer on where to look. Thanks again for
> your help.
>

Hi,

The form itself can be stored with the project
It is considered a module in the Organizezr so in Tools, Organizer, Modules,
move it into the file.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
<stephen.e.rich@intel.com> schreef in bericht
news:1142529353.381808.320260@j33g2000cwa.googlegroups.com...
> Thanks, I can definitely look it up in help now that I know what to
> search on. What would you suggest for storing objects if I need to in
> the future. Just need a pointer on where to look. Thanks again for
> your help.
>