Drop Down Box Length

B

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.
 
J

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_UserForm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
 
B

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??
 
B

BDankas

When I print it will it wrap the text?

Jay Freedman said:
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_UserForm_ListBox.htm goes into
more detail.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.


.
 
J

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.
 
B

BDankas

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

Is there an easier way to do this??
 
G

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/micr...ad/6abd389cc38d26b9/f8e84aa42868968d?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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top