Building a VBA Dropdown list


lotsof questions

I have a requirement to create in a form template a
dropdown list. The items in the list, not only exceed the
number of items, but the number of characters that the
built-in dropdown field can hold.

White building the list, is there code or a switch that
can be used to make or allow the text to wrap or break?



Doug Robbins

You can't wrap text in a dropdown list.

Take a look at the following Knowledge Base Article:

WD2000: How to Create Combo Box with More Than 25 Items [Q198561]

But then you might as well start with a UserForm.

See the article "How to create a Userform" at:

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - 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