DropDown Field 25 Item Limit

[Greg Maxey]

I have been meaning to post a Tips page on this subject on my web page for
quite a while and so I dusted it off and finished it up today. I departed
somewhat from the Microsoft KB Article 19856 suggestion to use a ComboBox
and I used a ListBox instead because a formfield dropdown doesn't function
like a combobox.

The method lets you use one userform and on entry macro for as many textbox
fields you want to use as for dropdown entry. It also sets the value in the
dropdown to match the current value in the textfield.

As always, I appreciate in constructive comments or suggestions for
improvement.

http://gregmaxey.mvps.org/FormField_UserForm_ListBox.htm

 

[alborg]

Hi Greg:

You might also demonstrate how to do the same, but using an outside MS
Access table to provide the values to the UserForm combobox.

An example of this is in my MS Word EMR Project downloadable from here:
http://www.box.net/shared/static/j0kmce8zzm.exe

Cheers,
Al