+ Reply to Thread
Results 1 to 4 of 4

Clicking on cell that auto fills an X and removes all other auto fills in a range

  1. #1
    Registered User
    Join Date
    06-27-2013
    Location
    Va Beach
    MS-Off Ver
    Excel 2003
    Posts
    38

    Clicking on cell that auto fills an X and removes all other auto fills in a range

    I would like a little help.

    I have the following code that allows me to click on a cells in a certain ranges and it places and "X" in the cell.

    Please Login or Register  to view this content.
    I would like it so that when I click on say C11, it would clear any other "X"s in the Range B11:E11 but would leave the other two ranges B13:D13 and B15:D15 alone. Same would hold true if I clicked D13 it would clear any other from B13:C13, but leave any "X"s in B11:E11 and B15:D15.

    Any help would be appreciated.
    Last edited by ERaasio; 12-26-2013 at 12:30 PM. Reason: Solved

  2. #2
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Clicking on cell that auto fills an X and removes all other auto fills in a range

    Hi,

    Maybe something like this
    Please Login or Register  to view this content.
    Thanks

  3. #3
    Registered User
    Join Date
    06-27-2013
    Location
    Va Beach
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: Clicking on cell that auto fills an X and removes all other auto fills in a range

    That worked except I had to set it up like this

    Please Login or Register  to view this content.
    That way it added the X to the blank cell but removed all the "X"s from that Row. Thanks a whole lot.

    PS - Added Rep for you. Thanks again.

  4. #4
    Valued Forum Contributor fredlo2010's Avatar
    Join Date
    07-04-2012
    Location
    Miami, United States
    MS-Off Ver
    Excel 365
    Posts
    762

    Re: Clicking on cell that auto fills an X and removes all other auto fills in a range

    I am glad it worked.

    Thanks

+ 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. Drop-Down Box which auto-fills another cell
    By kimi4989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2013, 11:53 PM
  2. [SOLVED] Drop down menu from a list that auto fills another cell
    By melliard5779259 in forum Excel General
    Replies: 5
    Last Post: 08-18-2013, 03:57 PM
  3. Locking a column that auto fills with time.
    By VICTORIE in forum Excel General
    Replies: 0
    Last Post: 05-23-2012, 04:22 PM
  4. auto fills
    By raymonddic in forum Excel General
    Replies: 6
    Last Post: 06-07-2007, 10:02 PM
  5. Question about auto fills or linking sheets
    By CEN in forum Excel General
    Replies: 4
    Last Post: 07-14-2005, 04: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