Results 1 to 3 of 3

How to find/edit the source list in data validation in a macro sheet?

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2022
    Location
    usa
    MS-Off Ver
    365
    Posts
    9

    How to find/edit the source list in data validation in a macro sheet?

    Hi, I need help ASAP. Please refer to the attachment. I have this macro file which has a drop-down list. Objective: To edit the list and add CAD model instead of RDM model?
    I tried to check the source in data validation, I see the source is "=Model_Options_NEW". Where is this coming from?

    When I checked the same in the Formulas tab- Name manager it says it refers to "=CALCS!$I$4:$I$6". I do not see this calcs sheet? if it is hidden how to unhide and edit it?

    Hoping to resolve this soon. Thanks
    Attached Files Attached Files
    Last edited by AliGW; 04-18-2022 at 12:54 AM. Reason: Urgency removed from title.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying a data validation list with original list source
    By Naz555 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-12-2017, 11:54 PM
  2. Too much IF in Data Validation List Source
    By Afrikite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2014, 10:21 AM
  3. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  4. [SOLVED] set data validation source list
    By rana_shaker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2012, 03:06 AM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  6. 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
  7. [SOLVED] combo box from data validation with source list in separate sheet
    By Jay Trull in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-06-2006, 10:10 PM

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