+ Reply to Thread
Results 1 to 9 of 9

How to Edit an Irregular Drop Down Box

  1. #1
    Registered User
    Join Date
    09-16-2020
    Location
    San Diego
    MS-Off Ver
    MS Office 2016
    Posts
    4

    Angry How to Edit an Irregular Drop Down Box

    Hello,

    I am working on an excel spreadsheet that seems to have a drop down box in one of the cells that isn't from excel. I cannot click on the drop down box to edit it. The drop down box is NOT protected. When I open the spreadsheet there is a security warning at the top of it that says enable content, and when I click on the the drop down box a formula pops up saying =EMBED("Forms.ComboBox.1",""). I click enable content on the security warning, and the formula goes away and I am unable to edit it completely. I have attached pictures of what I am seeing. I hope someone can help me! I just need to change the numbers from the drop down box.
    Attached Images Attached Images

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: How to Edit an Irregular Drop Down Box

    What happens if you select and right click the dropdown?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    09-16-2020
    Location
    San Diego
    MS-Off Ver
    MS Office 2016
    Posts
    4
    If I right click the drop down box nothing appears. If I right click the cell then it thinks nothing is in it, but the word ďSortĒ

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,365

    Re: How to Edit an Irregular Drop Down Box

    On the developer tab select Design Mode & then click on the combo.

  5. #5
    Registered User
    Join Date
    09-16-2020
    Location
    San Diego
    MS-Off Ver
    MS Office 2016
    Posts
    4
    Ahhh thank you! How do I edit the original one? And how do I edit the new one?

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,365

    Re: How to Edit an Irregular Drop Down Box

    In what way do you want to edit them?
    Please supply a sample workbook.

  7. #7
    Registered User
    Join Date
    09-16-2020
    Location
    San Diego
    MS-Off Ver
    MS Office 2016
    Posts
    4
    Quote Originally Posted by Fluff13 View Post
    In what way do you want to edit them?
    Please supply a sample workbook.
    I want to change the numbers from 1900 to 2000 in the drop down box. The numbers are linked to different pages. If I go to 1902 another page pops up. However, I need to change it to 2000. I cannot attach a work page because the information on this page is confidential. Iím sorry I realized if I click design mode I am able to change the size of the original combo box, I just donít know how to change the numbers.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,365

    Re: How to Edit an Irregular Drop Down Box

    Without knowing how the combo is being populated, I cannot help.

  9. #9
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    3,256

    Re: How to Edit an Irregular Drop Down Box

    If you want us to help you upload a cutdown desensitised workbook or send us a crystal ball.
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. Able to edit the cell that use drop down list
    By weakinexcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-22-2018, 04:04 AM
  2. Macro to EDIT Drop Down List
    By mithusaini in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2015, 07:06 PM
  3. [SOLVED] Edit a drop down list contents
    By worthm in forum Excel General
    Replies: 2
    Last Post: 12-18-2014, 06:21 PM
  4. [SOLVED] How to edit drop down macro?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 04:45 PM
  5. Cannot edit drop down menus
    By GreenLite2010 in forum Excel General
    Replies: 5
    Last Post: 01-28-2011, 02:54 PM
  6. 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
  7. [SOLVED] Edit Drop down box
    By kamill in forum Excel General
    Replies: 2
    Last Post: 08-11-2005, 09:05 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