+ Reply to Thread
Results 1 to 4 of 4

Limit in excel data validation source code

  1. #1
    Registered User
    Join Date
    Lagos, Nigeria
    MS-Off Ver

    Post Limit in excel data validation source code

    I have an excel file with two sheets. The second sheet (Report) contains data validation cells based on the first sheet (Data). From the second sheet, the drop-down list that displays in the Select XXX depends on the selection in the Generate Report. When the Generate Report is set to anything beyond the first five in its list, the Select XXX displays year as a default list (no problem with this) via the code `...INDIRECT("Year")...`. The problem is that excel does not allow for addition of more code (seems I hit the limit). The question is - how can I manipulate this code to accommodate every option in the Generate Report? or perhaps, is there another method to implement?

    The data validation source code for the drop-down list is
    HTML Code: 
    Please, see the sample file here drive.google.com/file/d/1VKkGHjlJzLQqx4J9kyd_bCKG4r0Q7HkG/view?usp=sharing

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365

    Re: Limit in excel data validation source code

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


  3. #3
    Forum Expert BMV's Avatar
    Join Date
    St-Petersburg, Russia
    MS-Off Ver

    Re: Limit in excel data validation source code

    I agee the example is necessory but you can try
    Please Login or Register  to view this content.
    R5:R9 =
    "Client","Month","Product_Service","Sector", "Trans_Type"

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2306 Win 11 Home 64 Bit

    Re: Limit in excel data validation source code

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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 with limit
    By excobra in forum Excel General
    Replies: 7
    Last Post: 06-01-2014, 02:07 AM
  2. Excel 2007 : Data Validation Character Limit
    By Magsy in forum Excel General
    Replies: 3
    Last Post: 09-12-2011, 05:09 PM
  3. Data Validation "Source" Box - Character limit?
    By gdallas in forum Excel General
    Replies: 6
    Last Post: 02-03-2010, 12:57 PM
  4. Replies: 0
    Last Post: 04-06-2009, 11:19 AM
  5. data validation-Can the source of the validation criteria be dfrom a different sheet?
    By yael pinkert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2009, 04:28 AM
  6. [SOLVED] [SOLVED] Is there a limit to the number of points in a chart source data
    By jantoni in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-09-2005, 11:45 AM
  7. [SOLVED] Range name limit for data validation
    By Paul K. in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-09-2005, 11:06 AM

Tags for this Thread


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