Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-16-2012, 08:16 PM
derby46a derby46a is offline How to link checkbox to change nearby cell value? Windows 7 64bit How to link checkbox to change nearby cell value? Office 2010 64bit
Novice
How to link checkbox to change nearby cell value?
 
Join Date: Aug 2012
Posts: 8
derby46a is on a distinguished road
Default How to link checkbox to change nearby cell value?

Hello,



I have a table in Word 2010 where I need to add tax to give me a total dollar amount. I have a check box called 'Tax Exempt?' in cell B12, and a formula in D12 which shows the tax in dollar amounts, =Product(D11,.0835), number format of $#,##0.00.

I want to be able to link the check box in B12 with the $ amount in D12 so that if I check the box saying this customer is tax exempt then D12 will read $0.00. Can I either:

(1) put a formula in D12 that says if check1 is true then put $0.00 in D12 and if not, then calculate the tax? If so, what would like formula look like? What I tried didn't work, 'Syntax Error'.
OR
(2) create a macro for D12 that does the same thing? If so, can you tell me the macro? I'm not very knowledgable about macros.

BTW, D12 was just created by inserting a formula via the Table Layout tab and selecting Formula. It wasn't created by inserting a text box using the Developer tab, so it doesn't have the ability to select Properties and then choose Run Macro upon Entry or Exit.

I would appreciate any help! Thank you.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Detect a cell has un-approved change or not? LongTTH Excel Programming 1 05-20-2012 02:22 AM
How to link checkbox to change nearby cell value? how to change number in cell ubns Excel 5 05-14-2012 04:21 PM
Link and change source for multiple tabs from excel to powerpoint excel3 PowerPoint 1 01-19-2012 02:01 AM
CHange colour of footer if a cell changes to red OTPM Excel 0 05-26-2011 07:15 AM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft