[BDankas]

I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.

[Jay Freedman]

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.

[Jay Freedman]

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.

[Graham Mayor]

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.

[Graham Mayor]

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.

[BDankas]

I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.


.

[BDankas]

I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.


.

[BDankas]

When I print it will it wrap the text?

"Jay Freedman" wrote:

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.
.

[BDankas]

When I print it will it wrap the text?

"Jay Freedman" wrote:

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT number of items
to choose from but number of characters on a line). Is there any work around
this? I want to create a form letter where the person creating the letter
has to choose between one paragraph or the other (using a drop down box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I needed
but not sure if this would work or how to do it.
.

[Jay Freedman]

The userform itself is never printable. The described solutions show how to
take the users's selection from the list box in the userform, and insert
that text into the body of the document. Once it's in the document, it's
just ordinary text, so it will wrap there.

BDankas wrote:
When I print it will it wrap the text?

"Jay Freedman" wrote:

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT
number of items to choose from but number of characters on a line).
Is there any work around this? I want to create a form letter
where the person creating the letter has to choose between one
paragraph or the other (using a drop down box). The form must be
lockable.

I was thinking about creating a macro that inserted the verbiage I
needed but not sure if this would work or how to do it.
.

[Jay Freedman]

The userform itself is never printable. The described solutions show how to
take the users's selection from the list box in the userform, and insert
that text into the body of the document. Once it's in the document, it's
just ordinary text, so it will wrap there.

BDankas wrote:
When I print it will it wrap the text?

"Jay Freedman" wrote:

The dropdown form field is limited to 50 characters per entry, and 25
entries. The solution for wider items is the same as the solution for
more items: create a userform containing a list box. Such a list box
can contain a practically unlimited number of items, each of hundreds
of characters (not that it can show them all, because it won't scroll
sideways).

The Microsoft KnowledgeBase article
http://support.microsoft.com/kb/198561 describes how to do it, and
Greg Maxey's page at
http://gregmaxey.mvps.org/FormField_...rm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 11 Mar 2010 15:09:01 -0800, BDankas
wrote:

I know that you can only have a drop down box be so long (NOT
number of items to choose from but number of characters on a line).
Is there any work around this? I want to create a form letter
where the person creating the letter has to choose between one
paragraph or the other (using a drop down box). The form must be
lockable.

I was thinking about creating a macro that inserted the verbiage I
needed but not sure if this would work or how to do it.
.

[Graham Mayor]

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.

[Graham Mayor]

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.

[BDankas]

I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.

[BDankas]

I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number of
items
to choose from but number of characters on a line). Is there any work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.

[Graham Mayor]

Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution
I came up with could easily be adapted to your requirements, but it will
require you to transfer some macros to your template and to add a userform.

That thread can be seen at
http://groups.google.com/group/micro...8968d?lnk=raot

It would be far simpler and quicker for me to add the userform to the
template than to try and explain it in simple terms - if you can send me
your template to the link on the home page of my web site.

I will need to know also the alternative texts associated with the
paragraphs and whether the template is for your own use or will be
distributed to others.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





"BDankas" wrote in message
...
I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on
the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number
of
items
to choose from but number of characters on a line). Is there any
work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.

[Graham Mayor]

Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution
I came up with could easily be adapted to your requirements, but it will
require you to transfer some macros to your template and to add a userform.

That thread can be seen at
http://groups.google.com/group/micro...8968d?lnk=raot

It would be far simpler and quicker for me to add the userform to the
template than to try and explain it in simple terms - if you can send me
your template to the link on the home page of my web site.

I will need to know also the alternative texts associated with the
paragraphs and whether the template is for your own use or will be
distributed to others.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





"BDankas" wrote in message
...
I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on
the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number
of
items
to choose from but number of characters on a line). Is there any
work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.

[BDankas]

Thank you Graham! I have sent you the requested information

"Graham Mayor" wrote:

Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution
I came up with could easily be adapted to your requirements, but it will
require you to transfer some macros to your template and to add a userform.

That thread can be seen at
http://groups.google.com/group/micro...8968d?lnk=raot

It would be far simpler and quicker for me to add the userform to the
template than to try and explain it in simple terms - if you can send me
your template to the link on the home page of my web site.

I will need to know also the alternative texts associated with the
paragraphs and whether the template is for your own use or will be
distributed to others.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





"BDankas" wrote in message
...
I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on
the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number
of
items
to choose from but number of characters on a line). Is there any
work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.



.

[BDankas]

Thank you Graham! I have sent you the requested information

"Graham Mayor" wrote:

Unfortunately there is a learning curve to vba programming, however, a
similar study came up recently in the vba programming group and the solution
I came up with could easily be adapted to your requirements, but it will
require you to transfer some macros to your template and to add a userform.

That thread can be seen at
http://groups.google.com/group/micro...8968d?lnk=raot

It would be far simpler and quicker for me to add the userform to the
template than to try and explain it in simple terms - if you can send me
your template to the link on the home page of my web site.

I will need to know also the alternative texts associated with the
paragraphs and whether the template is for your own use or will be
distributed to others.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org





"BDankas" wrote in message
...
I have followed all the various websites and still don't understand.

Is there an easier way to do this??

"Graham Mayor" wrote:

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"BDankas" wrote in message
...
I am not familiar with programming complex macros and the directions on
the
site are foreign to me (sorry). Do you have a step-by-step process??

"Graham Mayor" wrote:

See also http://www.gmayor.com/SelectFile.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"BDankas" wrote in message
...
I know that you can only have a drop down box be so long (NOT number
of
items
to choose from but number of characters on a line). Is there any
work
around
this? I want to create a form letter where the person creating the
letter
has to choose between one paragraph or the other (using a drop down
box).
The form must be lockable.

I was thinking about creating a macro that inserted the verbiage I
needed
but not sure if this would work or how to do it.


.



.



.