+ Reply to Thread
Results 1 to 4 of 4

Combo Box Mulitple Columns

  1. #1
    Registered User
    Join Date
    11-18-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combo Box Mulitple Columns

    Hi guys i was just needing some help with populating two columns within a combo box, i can populate the first one with no problems, but i have no idea how to even start on the second column.

    here is my code so far...

    Please Login or Register  to view this content.
    Last edited by Michael@Tafe; 11-18-2010 at 05:02 PM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Combo Box Mulitple Columns

    You'd better use code tags (# or ['code] ['/code], without hyphens). See the forum rules.

    Never use add.item populating multiple items.

    Please Login or Register  to view this content.



  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Combo Box Mulitple Columns

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

    PM me & I will open the solution for you
    Last edited by royUK; 11-18-2010 at 05:08 AM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    11-18-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Combo Box Mulitple Columns

    Quote Originally Posted by snb View Post
    You'd better use code tags (# or ['code] ['/code], without hyphens). See the forum rules.

    Never use add.item populating multiple items.

    Please Login or Register  to view this content.
    Not quite what i was looking for, but thank you for your help. See the sheet "Clients Temp", has a list of peoples names (first and last name A1 (first name),A2 (last name)) i was looking into changing the code so that it will use both the first and last name in the combobox. I should have explained it better but i was in a rush when submitting this post, so the code i need to alter is

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1