+ Reply to Thread
Results 1 to 4 of 4

Dynamic Data Validation VBA problem.

  1. #1
    Registered User
    Join Date
    04-12-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post Dynamic Data Validation VBA problem.

    Hello!
    At the first step sorry for my poor English, it's not my native language.
    I'm trying to modify the VBA code from Siddharth Rout (http://www.siddharthrout.com/2011/07...ent-lists-vba/) as promised to be amended to create more than 1 “Dependent Data Validation List“ in a different worksheet, without success...
    I would like to have data in 4 columns, as in Sheet2 and the result DV lists in Sheet3 exept the last column which is dependent constant as in attachement. Sheet1 contains oryginal data and VBA code. Could anybody help?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Dynamic Data Validation VBA problem.

    hi uhlik, wlecome to Excelforum, option, select A cell on sheet 3, then B, C
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-12-2014
    Location
    Poland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Dynamic Data Validation VBA problem.

    I thought about modification of the VBA code to 4 level DV list.

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Dynamic Data Validation VBA problem.

    please check attachment
    Attached Files Attached Files

+ 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] Dynamic Data Validation Dropdowns Problem
    By Cavinaar in forum Excel General
    Replies: 2
    Last Post: 12-17-2013, 08:44 AM
  2. Data validation problem involving dynamic issuses and tables
    By Masun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2013, 04:37 AM
  3. Dynamic Data Validation
    By SystemsAccountant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2008, 08:11 AM
  4. Dynamic Data Validation
    By taleb in forum Excel General
    Replies: 1
    Last Post: 09-13-2008, 08:08 AM
  5. [SOLVED] Data Validation - Dynamic
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-21-2005, 05:35 PM

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