+ Reply to Thread
Results 1 to 7 of 7

Add All option in each drpotionlist of combo box

  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Add All option in each drpotionlist of combo box

    Dear Friends,

    I have 3 ActiveX Combo box which are dynamic, I mean to say that the drop-down list changes by its own if we make any changes in the 3 column (Column XFA:XFC) from where the combo boxes are pulling it's list.

    Now I am trying to insert "All" option for each of the possible drop-down list in Combo-box 2 and Combo-box 3 without disturbing the data in column (XFA:XFC).

    For example:-
    If in comb-box 1 "Group 2" is selected then
    in combo-box 2 drop-down list should display (All, Latin America, Asia Pacific)
    and combo-box 3 should contain 3 different drop-down list for the above mentioned 3 Subgroups which are (All); (All, China H, Indonesia, Korea); (All, Malaysia, Philippines, Thailand)

    If required you can change the VBA code.
    Here is the file Dynamic Dependent Dropdown List From Column Data.xlsm

    If i am not clear with my description, then please ask me.

    Regards,

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Add All option in each drpotionlist of combo box

    Perhaps.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add All option in each drpotionlist of combo box

    maybe so
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    12-22-2013
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Add All option in each drpotionlist of combo box

    Thanks a lot Norie, you are savior a for me. One small thing one i want to ask you.

    Currently after making any selection in any of the combo box the next combo-box remains blank until we click on it and select out option. Norie is it possible to show the first option in drop-down list automatically as soon as the selection is done in the previous combo-box.

    I mean to say that, as soon as a user makes his selection in combo-box 1, immediately is it possible that automatically in combo-box 2 "All" (in our case) option gets displayed. Currently it remains blank.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Add All option in each drpotionlist of combo box

    Perhaps.
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-22-2013
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Add All option in each drpotionlist of combo box

    Nilem,

    Super, wonderful, lovely... before asking only you solved all my problems. I don't have words to express my happiness

    Thanks a lot for your help.

  7. #7
    Registered User
    Join Date
    12-22-2013
    Location
    Delhi, India
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Add All option in each drpotionlist of combo box

    Norie, as per your suggestion i tried it its working fine except for one thing.

    If i select "All" in combobox1 then in i don't get any option (or dropdown list) to choose from combobox2 and combobox3.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Populating combo box using option buttons
    By Alan72 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2013, 03:38 PM
  2. How to create option or combo box within cell?
    By mdivk in forum Excel General
    Replies: 18
    Last Post: 05-08-2013, 09:29 AM
  3. Combo box and option buttons
    By mike0123m in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-15-2011, 05:43 AM
  4. Combo Box Wizard, Option #3
    By gloria in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-28-2010, 11:14 AM
  5. Option Buttons and Combo Box Help
    By Mr.G. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-03-2009, 02:54 AM

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