+ Reply to Thread
Results 1 to 4 of 4

Selecting a cell in a range and alternately turn on/off an "X"

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    Fargo, ND USA
    MS-Off Ver
    10
    Posts
    32

    Selecting a cell in a range and alternately turn on/off an "X"

    Capture.JPG
    I have a range of cells on a sales order sheet highlighted in green which I would like to pick one of in this case 6. I would like to pick a cell, have it place an "X" and then have it go off if I pick an alternate cell within that range. I would like to use something like this rather than a drop down window so that all choices and data are available to see on the price sheet.

    Appreciate the help.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Selecting a cell in a range and alternately turn on/off an "X"

    If you search the forum for marlett checkboxes you will find many, many examples.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-28-2016
    Location
    Fargo, ND USA
    MS-Off Ver
    10
    Posts
    32

    Re: Selecting a cell in a range and alternately turn on/off an "X"

    Thanks - found exactly what I needed.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Selecting a cell in a range and alternately turn on/off an "X"

    You're welcome.

+ 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] VB error:"1004" Calculate method of range class failed when selecting a cell with Array
    By vayana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-25-2013, 06:48 PM
  2. Solution to populate cell with "X" by selecting "R"
    By nirola in forum Excel General
    Replies: 4
    Last Post: 11-17-2012, 10:15 AM
  3. Replies: 12
    Last Post: 10-15-2012, 03:57 PM
  4. Code for selecting a "floating" range
    By trey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2009, 06:22 PM
  5. Turn this "if" "or" statement into an excel formula
    By rmichaels55 in forum Excel General
    Replies: 6
    Last Post: 04-23-2009, 10:23 AM
  6. How to turn a cell "OFF" or Null it's Contents?
    By Mr. Green Genes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2006, 09:10 PM
  7. Replies: 6
    Last Post: 12-20-2005, 05:15 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