+ Reply to Thread
Results 1 to 3 of 3

SOLVED Auto Fill 2nd Combo Box based on answer in 1st Combo Box.

  1. #1
    Registered User
    Join Date
    12-19-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    28

    SOLVED Auto Fill 2nd Combo Box based on answer in 1st Combo Box.

    Hi everyone,

    I want to start by thanking everyone in this community for their time and support, I have honestly learned more from this community then you could possibly imagine.

    The project I'm working on requires the second Combo Box to be Auto populated based on the response in the first Combo Box. Through my readings I haven't been able to find the solution to this challenge.

    The attached example workbook opens as a user form and when you close it you will go to the workbook. I have pasted a couple of screen shots to illustrate what I'm trying to accomplish with this project.

    Thanking everyone in advance for your contribution(s).

    Cheers
    Attached Files Attached Files
    Last edited by BigHungarian; 02-16-2021 at 10:45 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Auto Fill 2nd Combo Box based on answer in 1st Combo Box.

    Put this in the Userform code module

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    12-19-2020
    Location
    Alberta, Canada
    MS-Off Ver
    365
    Posts
    28

    Re: Auto Fill 2nd Combo Box based on answer in 1st Combo Box.

    SOLVED! Spot on my friend Works like a charm, exactly what I was looking for.

    Thank You very much.

+ 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] User Form - Msg Box based on answer in Combo Box
    By BigHungarian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2021, 03:26 PM
  2. Populate 2nd combo with alpha based on 1st combo with 2 columns of numeric codes
    By dovermac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2014, 10:09 AM
  3. Auto fill cells based on combo box selection
    By rodriguez.guadalupe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2014, 09:08 PM
  4. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  5. [SOLVED] Fill combo box list based on other combo box values
    By rain4uu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2013, 03:04 PM
  6. Auto Fill 1 Txt from choices of 3 Dependant Combo boxes
    By Sabrina78 in forum Excel General
    Replies: 0
    Last Post: 10-13-2011, 12:59 AM
  7. Replies: 0
    Last Post: 05-22-2006, 03:45 PM

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