+ Reply to Thread
Results 1 to 2 of 2

Cascade Combo Box not in a userforum

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    Longview, Texas
    MS-Off Ver
    2003
    Posts
    15

    Cascade Combo Box not in a userforum

    I have Combo boxs that need to depend on another combobox. so that if ComboBox1 says "Canopy" combobox2 pulls up a list of canopy sizes.
    I know how to do it using Data Validation and the Indirect function, but I need the arrows that show up on a combo box. Can this be done in excel? Any advise would be great.
    Last edited by Glitch_; 10-17-2014 at 10:03 AM.

  2. #2
    Registered User
    Join Date
    10-09-2014
    Location
    Longview, Texas
    MS-Off Ver
    2003
    Posts
    15

    Re: Cascade Combo Box not in a userforum

    Figured it out.
    combo box is on the sheet titled "order sheet".
    If you look at the code in Programmnig!O4:UF on the attached sheet, you will notice how I created all the combo box linked to the cell that they were sitting on (look in the properties tab of the comboboxs and under LinkedCell link the cell to the cell that the combo box is sitting on) and used a true or false system for each option in Combobox1 (O4,P4,Q4) I used a IF function to create a second list (O5 to Q8), then I select the first column of the list (O5:O7) and labeled it "List1" then I went to the como box that needed to be dependent (ComboBox25) and in properties under the ListFill Range I put "List1" then process for each list (as seen from Programmnig!O4:UF).
    Attached Files Attached Files
    Last edited by Glitch_; 10-17-2014 at 10:04 AM.

+ 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. How to Run a Sub when ANY change takes place on a Userforum?
    By Overlord475 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2013, 11:13 AM
  2. Cycle Through Userforum TextBox and ComboBox in VBA
    By Overlord475 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-28-2013, 06:32 PM
  3. Hello Everyone, I'm Como
    By Como in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-22-2012, 02:04 PM
  4. [SOLVED] Disable Option in Como Box
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2005, 04:05 AM
  5. [SOLVED] Guardar .xls como .txt En Escritorio
    By Antonio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2005, 01:05 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