+ Reply to Thread
Results 1 to 2 of 2

Cascading Combo Boxes in User Form

Hybrid View

CRIMEDOG Cascading Combo Boxes in User... 02-27-2009, 01:20 PM
CRIMEDOG Re: Cascading Combo Boxes in... 03-02-2009, 10:44 PM
  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    667

    Cascading Combo Boxes in User Form

    This is my first Post:
    Excel 2007

    I am attaching the test work book
    I created a pricing tool using multiple worksheets (72)
    There are about 5 manufacturers and mutiple models
    I need to add the full row (starting with qty)

    Each model has multiple accesories
    Some accesories are required
    Some accesories cannot be added togethor

    I created a form that works using only formulas - but would rather use userboxes.

    Combo box 1 mfg - point to list on first sheet
    Combo box 2 point to list on different sheet (dependant on choice 1)
    combo 3 point to the model's sheet

    Is there a good tutorial that assumes no beginning VBA skills
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    667

    Re: Cascading Combo Boxes in User Form

    any ideas - I saw a post that uses a combo box then a list - what do you do is the ranges are on different sheets?
    i.e. choose mfg1 (ComboBox1) - than use range from mfg1! (ComboBox2) or choose mfg2 - then use range from mfg2!

+ 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