+ Reply to Thread
Results 1 to 3 of 3

Edit a drop down list contents

  1. #1
    Registered User
    Join Date
    10-13-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2010
    Posts
    99

    Edit a drop down list contents

    Hello,
    I am using MS Office 2010 and Ive got a drop down list I need to edit. The list contents are in a named range called "Ack letters?" on a sheet called Drop-down lists in cells as follows

    J1 Ack letters?
    J2
    J3 Yes
    J4 No
    J5 NA

    J2 is a blank cell

    The drop down is on sheet "Day 1" in cell H58. I've already edited the list by adding NA in cell J5 but I can't seem to get the actual drop down to recognize the change in the named range. How do I get the drop down list to recognize the change? Thanks for your help

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Edit a drop down list contents

    The DD is probably uing a named range, which is that range on the DD sheet. Go into the Name Manager (Formula tab), selecty that name and adjust the range to include your new entries
    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

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-13-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    2010
    Posts
    99

    Re: Edit a drop down list contents

    Thank you for the quick reply. I felt like I was missing something so I went to the Data/Data Tools/Data Validation section and it allowed me to add cell J5 to the list of drop down options. It works fine now

+ 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. Edit Drop Down Menu List
    By David A in forum Excel General
    Replies: 5
    Last Post: 01-10-2014, 12:59 AM
  2. Replies: 5
    Last Post: 03-01-2012, 01:56 PM
  3. How to edit a drop down list?
    By IPreferWord in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2009, 01:19 PM
  4. [SOLVED] Need a conditional drop-down list (list contents)
    By S&F Tie Guy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2006, 10:25 AM
  5. [SOLVED] Drop down list error after edit
    By theslaz in forum Excel General
    Replies: 5
    Last Post: 06-22-2005, 08:05 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