Re: UserForms - Templates and Documents



I was thinking that the Title could hold the some characters, even if
possibly not enough.

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"David Sisson" <dsisson@xxxxxxxxxxx> wrote in message
news:1117652396.201148.114690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> If the doc file is zipped and emailed to another user, the userform and
>> the line of code that shows the form is stripped
>
> Worked as designed.
>
>> Without forcing several hundred users to install add-ins or global
>> templates, is there a way to add the userform to the resulting doc file?
>
> Save the dot file as a doc file and distribute. I would password
> protect your code. But as Charles already stated, your end users will
> probably have macro security issues.
>
>> problem. The MsgBox function only allows 1024 characters in the prompt
>> string, and about 1200 are needed.
>
> The title property also has a 1024 limit, plus it gets trunicated after
> 76 characters.
>
> Create a userform with a label. Make the label as big as you need to
> hold your text.
>
> Another option would be to build a Windows help file and link it to the
> msgbox.
>


.