+ Reply to Thread
Results 1 to 3 of 3

Enable / Disable List based on Independent Cell

  1. #1
    Registered User
    Join Date
    04-06-2016
    Location
    Portland, OR
    MS-Off Ver
    Office 2013
    Posts
    2

    Enable / Disable List based on Independent Cell

    Hello,

    I am building a template using excel 2013 and I would like to enable/disable a list and allow free form entry in a cell based on the selection from an independent cell.

    For example, Cell A1 has a "Y" or "N" list enabled.

    If "Y" is selected, I want to enable a restricted drop down list in cell B2 (with options of $0.00 or $10.00 for example).

    If "N" is selected I want users to be able to input any dollar amount they choose in B2.

    Is this possible? Any help is greatly appreciated!

    Thank you!

  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,945

    Re: Enable / Disable List based on Independent Cell

    Just remove the STOP from the error message window. This will allow you to enter whatever you want, but it will throw up a message saying that what was not what it expected
    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
    04-06-2016
    Location
    Portland, OR
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Enable / Disable List based on Independent Cell

    Thanks FDibbins, is there a way to keep the STOP error intact for the list, but allow for free form entry with a "N" selection in cell A1?

+ 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] How to Disable / Enable specific columns based on the input from a cell
    By praveenkagitala in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-02-2014, 11:58 PM
  2. Disable/Enable Combo Box (Drop Down List)
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2014, 12:10 PM
  3. enable and disable cells based on the value of another cell
    By Emma_B in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-09-2013, 08:06 AM
  4. Enable/Disable cell based on other cell
    By montoya in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-02-2013, 04:24 PM
  5. Replies: 1
    Last Post: 08-10-2012, 10:01 AM
  6. [SOLVED] Enable and disable a cell based on a combination
    By Tandrima in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-25-2012, 12:26 PM
  7. Enable/disable button from list selection
    By Matt75 in forum Excel General
    Replies: 2
    Last Post: 08-14-2010, 10:40 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