Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box Behaviour (XP 2003)

    Good morning

    I have a combo box that needs to show information from 2 columns (A + [img]/forums/images/smilies/cool.gif[/img] from another page but when selected only insert the information from column A, for example the user clicks the combo box and is shown the following

    AC Animal Container
    AS Assembly service fee
    AT Attendant
    AW Air Waybill Fee
    BL Blacklist Certificate
    BR Bank release

    He wishes to choose AW Air Waybill Fee and clicks it and only AW would appear in the combo box on the form

    Is this possible and how would I acheive it please

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Combo Box Behaviour (XP 2003)

    You can do this using a combobox from the Control Toolbox. Set its columncount to 2, bound column to 1, ListFillRange to the 2 column range you want, and its LinkedCell to the cell where you want the output. Do you want this for multiple rows, or just one?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Behaviour (XP 2003)

    Thanks Rory

    That worked fine, there will be 4 different areas on the form that the combo box will be needed but I have just copied and pasted it and linked it to the specific cells as suggested.

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •