+ Reply to Thread
Results 1 to 4 of 4

Checkbox that changes a cells number value?

  1. 07-16-2015, 01:14 AM #1
    Plutoh
    Plutoh is offline
    Registered User
    Join Date
    07-16-2015
    Location
    United State
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    3

    Checkbox that changes a cells number value?

    Is it possible and if so how to put a checkbox next to a small cell containing text of lets say $10 and when the checkbox is ticked it changes the value of $10 to $0 or whatever. Been searching and couldn't find anything to help. Figured asking on a forum would be my best bet. Plus I get to learn new things I wouldn't of thought of. Thanks -
    Reply With QuoteRegister To Reply
  2. 07-16-2015, 01:27 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Checkbox that changes a cells number value?

    See the attached file..

    Is this what is required?
    Attached Files Attached Files
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 07-16-2015, 01:33 AM #3
    Plutoh
    Plutoh is offline
    Registered User
    Join Date
    07-16-2015
    Location
    United State
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    3

    Re: Checkbox that changes a cells number value?

    Yes exactly. How do you perform that? Teach me
    Last edited by Plutoh; 07-16-2015 at 01:40 AM.
    Reply With QuoteRegister To Reply
  4. 07-16-2015, 01:36 AM #4
    Plutoh
    Plutoh is offline
    Registered User
    Join Date
    07-16-2015
    Location
    United State
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    3

    Re: Checkbox that changes a cells number value?

    Also how would you make it so instead of changing the value it puts a strike through it?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Checkbox on / off applying to cells only in the same row as the checkbox
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2012, 08:28 PM
  2. Replacing checkbox number with integer?
    By andy.allard in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-09-2011, 09:49 PM
  3. Copy X Number of Rows Based on Checkbox, and Calculate High Point?
    By djpony in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2011, 05:01 PM
  4. How Do I select cells (with a checkbox) and sum them
    By spamunch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-12-2011, 06:42 PM
  5. [SOLVED] Adding a Checkbox in Cells
    By Chaplain Doug in forum Excel General
    Replies: 3
    Last Post: 05-15-2006, 11:10 AM
  6. Need checkbox automatically in some cells of a new row
    By stuff8458 in forum Excel General
    Replies: 0
    Last Post: 11-08-2005, 05:10 PM
  7. [SOLVED] Use merged cells as checkbox
    By W M in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1