jaxrotors
11-06-2008, 02:14 PM
Hi,
I am trying to add an element to a Word form that will allow the user to select one item from a long list (300+ items). I initially tried to use a pulldown object to feed a value to the userform Listbox as an initial value. The idea is to use the alphabet as a shorter starting list to make the long list managable.
I ran into a problem with the "focus" on the object not allowing a change to the value without leaving the pulldown object and returning.
Now, as a work around, I'm trying to use two list boxes inside the userform. I want the first to load populated with A - Z and have the second list box to populate on user selection of a value in the first. For example, if the user selects A in the first box, the second box would list all of the items in the "A" array.
I can't find any information about how to do this, or if it is even possible. Can someone please point me in the right direction?
Thanks!
:banghead:
I am trying to add an element to a Word form that will allow the user to select one item from a long list (300+ items). I initially tried to use a pulldown object to feed a value to the userform Listbox as an initial value. The idea is to use the alphabet as a shorter starting list to make the long list managable.
I ran into a problem with the "focus" on the object not allowing a change to the value without leaving the pulldown object and returning.
Now, as a work around, I'm trying to use two list boxes inside the userform. I want the first to load populated with A - Z and have the second list box to populate on user selection of a value in the first. For example, if the user selects A in the first box, the second box would list all of the items in the "A" array.
I can't find any information about how to do this, or if it is even possible. Can someone please point me in the right direction?
Thanks!
:banghead: