LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Using check boxes to include/exclude data in calculations

I have several columns of numbers being used in various calculations on a
spreadsheet. I would like to place a check box at the top of each column and
be able to select or de-select the checkbox to determine whether or not the
numbers in that particular column are included in the calculations. Can
anyone assist me with a macro that would accomplish this?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying data using Check boxes Anil Kumar N.[_2_] Excel Discussion (Misc queries) 0 January 16th 08 08:38 AM
Include/Exclude Holiday from Automatic Sheet Creation David Excel Discussion (Misc queries) 0 August 27th 06 04:51 PM
Check boxes and extracting the data [email protected] Excel Discussion (Misc queries) 5 April 7th 06 06:41 PM
Use networkdays INCLUDE weekends, Exclude holidays ronnomad Excel Worksheet Functions 4 December 16th 05 04:55 PM
Check Boxes & Data Validation Mike R Excel Discussion (Misc queries) 4 October 4th 05 06:47 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"