+ Reply to Thread
Results 1 to 10 of 10

Dependent Combo Box

  1. 08-03-2012, 03:44 AM #1
    eltonlaw
    eltonlaw is offline
    Registered User
    Join Date
    06-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    55

    Smile Dependent Combo Box

    Dear Expert,
    As shown in the file, is it possible or how can do we limit the choices from one combo to Second combo

    That is If we choose group 1, choices in combo 2 can only be Ann, Jasmine and Tinny.
    Also, if we choose group 1, choices in combo 3 can only be Monday, Wednesday and Friday.

    Can this be done or have to config by VBA?

    Thanks so mcuh for advice.

    Thanks
    Elton
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-03-2012, 04:00 AM #2
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Dependent Combo Box

    as an option
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
  3. 08-03-2012, 04:05 AM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Dependent Combo Box

    Hi

    Why don,t you use just Dependent Lists?

    http://www.contextures.com/xlDataVal02.html

    ---------- Post added at 09:05 AM ---------- Previous post was at 09:03 AM ----------

    Hi John!

    Long time didn't see you here!
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 08-03-2012, 04:08 AM #4
    eltonlaw
    eltonlaw is offline
    Registered User
    Join Date
    06-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Dependent Combo Box

    Hi John,
    That is amzaing. Thanks so much.
    Elton

    ---------- Post added at 04:08 PM ---------- Previous post was at 04:07 PM ----------

    Hi Fotis, thanks for help too.
    That is great ....
    Elton
    Reply With QuoteRegister To Reply
  5. 08-03-2012, 04:09 AM #5
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Dependent Combo Box

    Glad it helped you!
    Reply With QuoteRegister To Reply
  6. 08-03-2012, 04:11 AM #6
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Dependent Combo Box

    Me too

    John: Long time did't see you here. How are you?
    Reply With QuoteRegister To Reply
  7. 08-03-2012, 04:18 AM #7
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Dependent Combo Box

    Hello Fotis,
    I'm fine, thx! I was let's say "busy" with my junior, graduation, college admission!
    Reply With QuoteRegister To Reply
  8. 08-03-2012, 04:25 AM #8
    eltonlaw
    eltonlaw is offline
    Registered User
    Join Date
    06-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Dependent Combo Box

    Hi John,
    Sorry to both you again.
    Is it possible to have an export button to populate the selected data in sheet 2 row 1 ...
    Say Group 1 in Sheet 2 A1, Ann in sheet 2 B1 and Monday in Sheet 2 C1 ...
    Any new selection after pressing export will be automatically going to row 2.
    Can this be done?
    Thanks so much
    Elton
    Reply With QuoteRegister To Reply
  9. 08-03-2012, 04:40 AM #9
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Dependent Combo Box

    hi,
    add a commandbutton to your userform and add this piece of code (to commandbutton), see if it helps you
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 08-03-2012, 04:53 AM #10
    eltonlaw
    eltonlaw is offline
    Registered User
    Join Date
    06-27-2011
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Dependent Combo Box

    Thanks a million
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1