+ Reply to Thread
Results 1 to 2 of 2

Cells reset formula from a Dropdown list

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Question Cells reset formula from a Dropdown list

    I have a cell with a dropdown list, with one of the list values abeing blank.

    Is there a way please to have a formula in the blank space of the dropdown list that when selected from the dropdown list it will Clear Contents of a specific cells to have them ready for a new entry.

    The specific cells are;
    D3, D4, D6, D8, D10, E3, E4
    Last edited by Khaldon; 10-05-2018 at 10:31 AM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Cells reset

    Please take the time to review our rules. There aren't many, and they are all important.

    Rule #1 requires good thread titles. Before continuing please update your title to something that summarizes your question. The original title does not give insight as to the problem you are trying to solve.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  2. Trying to add 7 cells but get to reset when a cell is zero
    By DonnaLynn in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-11-2016, 08:53 PM
  3. [SOLVED] Every Certain Sum I want to Reset My Cells - Need Equation
    By neelpatel in forum Excel General
    Replies: 9
    Last Post: 07-30-2012, 01:02 AM
  4. Reset cells to zero
    By no dice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2007, 10:20 PM
  5. [SOLVED] reset certain cells to a default value
    By JcR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2006, 01:25 PM
  6. [SOLVED] reset cells to 0 all at once
    By Workshops in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-19-2006, 08:45 PM
  7. [SOLVED] reset cells
    By 1vagrowr in forum Excel General
    Replies: 8
    Last Post: 12-21-2005, 01:20 AM

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