Re: Listbox2 with items from listbox1

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jean-Guy Marcil (no-spam_at_leaveme.alone)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 14:43:06 -0500

Moretakitty was telling us:
Moretakitty nous racontait que :

>> So why not just fill the second list when you create the form? Why do
> you need to fill the second with the exact same content ...
>
> The user would only need to chose some of the items from the first
> box, not all of them.
>

This is still confusing, or I need a vacation!
It seems you are building a protected on-line form.

There are no listboxes on the form toolbar, just dropdown boxes (Dropdown
boxes - or ComboBoxes - do not allow multiple selections, but listboxes do).
Because you have more than 25 items, you have to go the VBA way, and then it
is possible that your form dropdown be linked to a VBA listbox instead of
the usual combobox.
I guess you used the procedure outlined at: KB 198561
    http://support.microsoft.com/default.aspx?scid=kb;en-us;198561&Product=ofw

Even if the user selects more than one item in the listbox that appears when
he selects the dropdown on the document page, when the user gets back to the
page, the dropdown will display only one item. If we disregard that and
populate a second VBA listbox with the selected items from the first one,
still, the Word document will only display one of those in the second
dropdown...

I am sorry, but before we get involved with code, I have to understand what
you are doing otherwise I may end up leading you on the wrong path and waste
time for both of us. It may be complicated, or very simple... I have no idea
yet because I cannot see the purpose of what you are trying to do. Normally,
the task is to populate a second dropdown with a series of item based on a
selection in a first dropdown (E.g. if I selected "Fruits" in the first one,
the second one would be populated with Apple, Banana, Pear, Kiwi, Passion
fruit, etc; but if I had selected "Vegetables", then the second one would
have been populated with Peas, Bok Choi, Carrots, Asparagus, etc.). Now you
seem to be wanting to transfer items from one dropdown top another on the
fly... which is very strange to me. 

-- 
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Relevant Pages

  • Re: Word form dropdown and Userform listbox
    ... The userform is triggered by a macro on the enter event of the ... listbox once the user clicks on an "OK" command button. ... both the dropdown and textfield have been populated. ... I'd also want a more exact account of what "get the listbox values to filter ...
    (microsoft.public.word.vba.general)
  • Re: Help with creating custom ComboBox
    ... emulating the dropdown on the Pocket PC's File Explorer (background color, ... decorating image to sit beside the text, listbox or tree dropdown, floating ... > the native framework ComboBox, I've attempted a quick and dirty ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Listbox problem
    ... Thankīs a lot Jason! ... > You can send the F4 key to the system to close the dropdown. ... > combobox. ... >> then it setīs focus to my listbox. ...
    (microsoft.public.access.formscoding)
  • Re: Changing the order in dropdown boxes?
    ... I wrote something along the lines - it works but...- could Tom Ogilvy proof ... Listbox with values - up 7 columns squeeze there OK ... Support for ranges up to 14 columns wide, input boxes will appear as ... The form is best invoked by DblClick event on a dropdown. ...
    (microsoft.public.excel.programming)
  • Re: List boxes in Microfocus Dialog System/Net Express?
    ... >the users wouldn't be required to remember 6 codes for data entry. ... >Instead of positioning the listbox to the row that I want a new row is ... - display Dropdown List and make selection ... now you redisplay any Client Record - OK so far? ...
    (comp.lang.cobol)