cascading

  1. N

    Multiple Selection on a dependent / cascading drop down list

    Hello all, I am trying to put together a sign-off sheet of responsibilities within my organization. To do so, I've created two cascading drop-down lists via Data Validation: Independent Drop-Down: Department within the organization Dependent Drop-Down: Position in the corresponding department...
  2. D

    Please help condense cascade into a single row

    I'm trying to build out a deployment forecast that has two main components: a probability of the deal's timing in a given period, and a % of the deal deployed in a given period. For example, suppose we're forecasting a deal with 100 devices. If there's a 100% probability it closes in...
  3. A

    Cascading drop-down data validation lists with only unique items.

    Here is a gross over-simplification of my dataset in Excel (it's larger and more purposeful than this). It's in a table, at this point with quite a few more columns and vastly more rows. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...
  4. J

    Multiple Cascading Comboxes in Userform

    I'm trying to setup multiple cascading comboboxes in a userform. I've been able to get combobox2 to show the relevant managers for the selected entity in combobox1 (example: if I select Entity 4 (in combobox 1), it should display Apple and Cash & Equivalent in Combobox2). However, I would like...
  5. S

    Cut and pasting data into new work sheet

    Hi Experts I'm a newbie to VB and I am trying to figure out how to cut and paste data from the first work sheet into other work sheets. Here is the catch however: Sheet 1 has 10 tables that is cascading. therefore i need to figure out a way to cut and paste each table into a new work sheet...
  6. T

    Multiple Cascading Drop Downs

    I have created cascading drop downs using the approach outlined here http://www.contextures.com/xlDataVal02.html I have the following 1. Concept Area (List 1) 2. Subject area within each concept area (List 2) 3. Entity within each subject area (List 3) The only issue I have is if I say...
  7. A

    Creating multiple (5) drop down lists, all dependent on the selection(s) of the prior

    I need to put together a worksheet that assists users in selecting a valid account for posting activity. Prior to viewing a list of acceptable account numbers (with full descriptions), the user must 1st select from 4 other drop downs. Column A has 2 possible selections Column B has 2 possible...
  8. A

    UserForm outputs to cells in a series of rows

    I wonder if anyone can help me. I've created a userform with cascading comboboxes and other fields and when completed the userform populates cells B3:H3. The problem that I'm running into is that I need the form to populate the next row with the next entry of information. For example, the...
  9. A

    How to populate comboboxes with range from a different worksheet?

    I wonder if anyone can help me. I'm trying to load the comboboxes with data from a different worksheet. However, no matter what code I try it only loads from the active sheet. Here's an example of one of the subs that I tried. Any help would be greatly appreciated! Private Sub...
  10. A

    Cascading ComboBoxes

    I apologize if this is too elementary for some on the forum. I'm just trying to create a user form with two cascading comboBoxes (i.e. the list in box2 is dependent on the selection in box1). I've looked all over and have tried various code suggested on different forums, but I just can't get...
  11. S

    Cascading combos too complex

    Hello all. I'm trying to create a series of 3 cascading combo boxes using a technique I found on this board. The first combo (cbo.Areas) contains a list of "Body Areas" derived from the table of the same name (with columns: AreaID and AreaName). The second combo (cbo.Parts) lists more...
  12. D

    VBA - Populate 3 cascading Listboxes with Data found on a Spreadsheet that cant be changed

    Hi at all! I got a big table in the following style: vegetable green zucchini vegetable green broccoli vegetable red tomato fruit red strwaberry fruit red raspberry fruit yellow banana I already managed to have 3 listboxes popping up subsequently but...

Some videos you may like

This Week's Hot Topics

Top