+ Reply to Thread
Results 1 to 3 of 3

Clear cell contents based on value selected in a dropdown list

  1. #1
    Registered User
    Join Date
    01-11-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    10

    Clear cell contents based on value selected in a dropdown list

    I know this has been asked before but I can't seem to get any of the solutions to work for me. I appreciate any help & I'll try to be as detailed as possible.

    > Excel 2013
    > Sheet name: "Data Entry"
    > I have a dropdown list in cell C4 that contains four options ("swim", "bike", "run", "other (weights, yoga, etc...)". When a user selects one of the items then I need the data in a few other cells cleared out.

    So,
    (1) if the user selects "Run" or "Bike" I need cells D8 & D10 cleared out
    (2) if the user selects "Swim" I need cells C8, C10 & E10 cleared out
    (3) if the user selects "Other (Weights, Yoga, etc…)" I need cells C8, C10, D8, D10, & E10 cleared out

    Thanks for your help.
    - David

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Clear cell contents based on value selected in a dropdown list

    • Right-click on your Data Entry tab
    • Select View Code from the pop-up context menu
    • Paste the code below in the worksheet's code module


    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 12-01-2013 at 01:37 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    01-11-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Clear cell contents based on value selected in a dropdown list

    Thank you AlphaFrog! Works like a charm!!

+ 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] Clear contents based on contents of another cell
    By Katrina DTE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2013, 02:44 PM
  2. Clear cell contents based on offset of dropdown selection on another tab.
    By Drivium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 10:58 PM
  3. Change cell from dropdown list and clear other cells in row
    By Dale Schultz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 09:30 AM
  4. Clear contents based on value in another cell
    By RochesterColonial in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2010, 12:01 PM
  5. Automatically clear contents of cell when selected
    By staples in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-15-2009, 03:48 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