+ Reply to Thread
Results 1 to 4 of 4

Creating cascading data validation lists/combo boxes without named ranges

  1. #1
    Registered User
    Join Date
    06-02-2014
    Posts
    11

    Creating cascading data validation lists/combo boxes without named ranges

    Is there a way to add cascading lists (from data validation or form/activex controls) to my excel spreadsheet WITHOUT using named ranges? Maybe structured references?

    I need to avoid the named ranges because it will cause my workbook to have duplicate named range titles which I cannot avoid.

    As a general example my issue arrises because I have something like this where the titles are the same but they map to slightly different data. These also have to be cascading because the titles align to another list which I do not show in the example. I also considered using pivot tables, but the issue there is that the data validation lists repeat in the same worksheet. So I would have 3 cascading lists in row1 dependent on eachother, but the same 3 lists in row2 dependent on row2 but not the previous row.

    Please Login or Register  to view this content.

    Hope this makes sense. Please ask questions if you dont understand fully. I cant post my workbook because it is company work.

    Thanks!

  2. #2
    Registered User
    Join Date
    06-02-2014
    Posts
    11

    Re: Creating cascading data validation lists/combo boxes without named ranges

    Follow up, I created a table and tried using =Indirect(table1[[#data],[" & somecell here with name & "]]". It works but I get lots of blanks because my table has columns of data with different lengths. If there is a way to avoid the blanks, that could be a possible solution.

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Creating cascading data validation lists/combo boxes without named ranges

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    06-02-2014
    Posts
    11

    Re: Creating cascading data validation lists/combo boxes without named ranges

    Thanks newdoverman. I was actually able to solve my issue using this link:
    http://www.excelforum.com/excel-gene...ed-ranges.html

+ 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. Replies: 5
    Last Post: 07-28-2014, 11:53 AM
  2. [SOLVED] Adding dynamic named ranges to combo boxes in userform
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2013, 09:45 AM
  3. Changing code to allow for multiple data validation lists/combo boxes
    By StatsN3rd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 02:12 PM
  4. Help with Named Ranges used in Validation Lists
    By BarbaraNie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2012, 10:04 AM
  5. assigning data to lists boxes and combo boxes in userforms
    By weston.roberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2011, 03:11 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