+ Reply to Thread
Results 1 to 7 of 7

Excel - populating data (checkboxes) based on combo box selection

Hybrid View

  1. #1
    Registered User
    Join Date
    06-23-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel - populating data (checkboxes) based on combo box selection

    Hi Leith,
    I noticed you helped out an individual on this forum (similar to what I am currently struggling with), so I thought you would be a lifesaver!

    I'm creating an Excel 'form' where the combo box values are a list of countries (approximately 75). Based on selection, the cells to the right would populate all "responsibilities" associated with that country. As mentioned above, I found a similar example, however, what I'm having trouble with now is adding additional countries and adding additional lines/responsibilities with checkboxes. Each time I try to add a new line to the list, I'm getting an error. Please help! I've spent hours and I'm not getting anywhere...
    Attached Files Attached Files
    Last edited by gkang116; 06-28-2011 at 05:29 PM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Excel help - Leith

    Hi gkang116 and welcome to the forum. Please amend your title as per rule #1 of the forum rules located here. Once you do that, someone (Leith) will be able to help you.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Excel help - Leith

    Hello Grace,

    @ Mordred - Thanks for pointing out the rule. The OP contacted via PM. Because this a first post, I wanted to see the workbook to help suggested a proper name for the thread.

    Is this the post you are referring to http://www.excelforum.com/excel-prog...a-library.html? Do you want to use a similar setup with your UserForm?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    06-23-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel help - Leith

    Hi there,
    Sorry about that - I signed up a few days ago and wasn't aware of the rules. My apologies again!

    Leith, the post I'm referring to is: http://www.excelforum.com/excel-prog...down-menu.html

    As mentioned, I just need to add to my list (additional countries and more lines of responsibilities).

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Excel - populating data (checkboxes) based on combo box selection

    Hello Grace,

    That was a novel idea. I can make the needed changes to your workbook so it does the same thing.

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Excel - populating data (checkboxes) based on combo box selection

    Hello Grace,

    You did a great job converting the code to your workbook. It works fine. To expand the Project lists, simply click on the last cell in the list. A new row will appear with an asterisk "*". Type the new information in and repeat. Everything else is adjusted automatically.

+ 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