+ Reply to Thread
Results 1 to 1 of 1

Data Validation (Dynamic) Drop Down WITH COMBO BOX on DOUBLE CLICK, INDIRECT not working

  1. #1
    Registered User
    Join Date
    07-25-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    86

    Data Validation (Dynamic) Drop Down WITH COMBO BOX on DOUBLE CLICK, INDIRECT not working

    Hi, I have made some drop down menus using the data validation technique. This is a three tier system and it works perfectly fine. However I have decided to add a combo box overlay that appears on double click using the code below. This works for the first set of drop downs, but not the second and third tier (I'd imagine because they use INDIRECT, within the sourcing). I have attached the file that I am working with, any help is appreciated.

    Please Login or Register  to view this content.
    I have tried using the following, to convert the "indirects" to proper cell references but have had no luck.
    Please Login or Register  to view this content.
    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] Data Validation (Dynamic) Drop Down WITH COMBO BOX, INDIRECT not working
    By georgedixon in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-27-2017, 10:04 AM
  2. [SOLVED] Indirect data validation with dynamic range not working.
    By skyping in forum Excel General
    Replies: 3
    Last Post: 03-03-2017, 07:52 AM
  3. Replies: 4
    Last Post: 08-25-2016, 01:50 PM
  4. [SOLVED] Data validation problem (double drop down list)
    By bilenberg in forum Excel General
    Replies: 13
    Last Post: 04-03-2016, 10:37 AM
  5. Data Validation Combo Box - Indirect Function/Limit to one column
    By AlliG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2013, 07:48 PM
  6. [SOLVED] Indirect Validation after using SUBSTITUTE on a Dynamic Name Range NOT WORKING
    By Jason Eric in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2013, 04:26 AM
  7. Dynamic Data validation and the indirect function
    By jboyd123 in forum Excel General
    Replies: 1
    Last Post: 01-13-2011, 06:32 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