LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default CHECK BOX HELP NEEDED

CHECK BOX HELP PLEASE.

My sheet contains 80 rows. (80 competitors). Their results are posted, one
row to a competitor. Starting on row 7 - 87

I have a check box (default €“ unchecked) in cell K7. Its purpose is to
indicate, whether the competitors times qualify for the event, There are
three timers. The three times are averaged to give €śThe Time€ť. If they run
over their time, this checkbox should be clicked and the previously entered
times in C7,E7,E8 should be replaced with NIL.
This check box will be in Col k on every row.
I can record a macro to do this on that line, but I want to use a relative
function so that I can copy it down the page to make give the same code to
every row, instead of having 80 macros. I have nearly been there but
everytime I get close, I seem to come up with something not quite right. Any
help very much appreciated.

 
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
Check box hero needed please. Kev Excel Discussion (Misc queries) 3 June 7th 07 02:44 PM
formula needed to sum check marks veena Excel Worksheet Functions 1 February 24th 07 01:52 AM
formula needed to sum check marks john Excel Worksheet Functions 0 February 22nd 07 09:58 PM
formula needed to sum check marks veena Excel Worksheet Functions 0 February 22nd 07 09:57 PM
CHECK BOX HELP NEEDED PLEASE SYBS Excel Programming 1 September 7th 05 06:53 PM


All times are GMT +1. The time now is 10:17 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"