 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006use "button" to make calculation ignore a cell
How can I create a macro "button" over a series of columns that will cause a formula in another part of the sheet to ignore the value that the column calculates to? i.e. X X X 20 60 9 40 50 21 _______________ 60 110 30 =200 I would like to click on the button (represented by the X) or perhaps more than one button, have the button change appearance and then that column total wouldn't be used to calculate the answer (200) Does that make since? Use View | Toolbars to display Forms tool Make a check box on the worksheet; link it to a cell The check box gives a values of TRUE (1) or FALSE (0) to a cell I linked three check boxes to A3, B3, and C3 I had three numbers in the rows below each I used formula =SUM(A4:A6)*A3+SUM(B4:B6)*B3+SUM(C4:C6)*C3 You can format and move the checkbox to hid the linked cell best wishes  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > How can I create a macro "button" over a series of columns that will cause > a formula in another part of the sheet to ignore the value that the column [quoted text clipped - 12 lines] > > Does that make since? Thanks for the quick reply How do I link it? I can assign macros of course but not "Link" I'm using XL2003 > Use View | Toolbars to display Forms tool > Make a check box on the worksheet; link it to a cell [quoted text clipped - 21 lines] >> >> Does that make since? Right click CheckBox Use Format Control from menu Open Control tab and locate Cell Link box I find it best to click on the cell with the dialog open rather than type cell reference best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Thanks for the quick reply > How do I link it? I can assign macros of course but not "Link" [quoted text clipped - 25 lines] >>> >>> Does that make since? OK got that, in your formula: =SUM(A4:A6)*A3+SUM(B4:B6)*B3+SUM(C4:C6)*C3 does the "*A3" tell the formula to evaluate if the link in A3 is true? Is that how it works? Ahh I see, it multiplies by 1 or zero depending on state. Genius! Thanks a bunch! > Right click CheckBox > Use Format Control from menu [quoted text clipped - 31 lines] >>>> >>>> Does that make since? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.