+ Reply to Thread
Results 1 to 4 of 4

2nd column of combobox disappears once selected

  1. #1
    Registered User
    Join Date
    07-13-2011
    Location
    Boston, MA USA
    MS-Off Ver
    Excel 2010
    Posts
    28

    2nd column of combobox disappears once selected

    I have successfully filled a multicolumn combobox with 2 columns of data using VBA code that finds the data in a worksheet table. My only problem with it is that the 2nd column disappears when (and only once) the user makes a selection. I USE the second column from the selection in further processing, and that works fine. It just no longer appears in the combobox after a selection is made.
    FYI, Column Count is set to 2 and Bound Column is 2.
    Any ideas?
    Thanks so much!

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: 2nd column of combobox disappears once selected

    Hi

    I think it would help if you posted your code and sample sheet

  3. #3
    Registered User
    Join Date
    07-13-2011
    Location
    Boston, MA USA
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: 2nd column of combobox disappears once selected

    I currently have NO CODE associated with clicking the combobox, cboPart, but the drop button click nevertheless works fine to display its contents and I'm able to select an entry and refer to the cboPart.Value.

    My code to fill the combobox follows:
    Please Login or Register  to view this content.
    What else might be helpful to show you given that the combobox displays the appropriate content (with both columns) when clicked, but only the first column after the selection is made?
    Thanks.

  4. #4
    Registered User
    Join Date
    07-13-2011
    Location
    Boston, MA USA
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: 2nd column of combobox disappears once selected

    Are people not able to replicate this problem?
    Does no one else get the same result?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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