|
|
#1
11-26-2014, 08:02 AM
|
|||
|
|||
Create check box to insert current time
I'm using Excel 2010 and need to create a check box that will insert the current time (24 hour format) into the next column.
I was able to create check boxes in the attached spreadsheet, but any time a single check box is updated (clicked or unclicked), ALL of the values in the next column change. Each check box should ONLY affect the value in that row. What am I doing wrong? Thanks! Doug 
|
|
#2
12-07-2014, 07:52 PM
|
|||
|
|||
|
Excel recalculates all formulas every time a change is made anywhere in the worksheet. If you want to retain the time the checkbox was ticked you will need some VBA to replace the formula with a value.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Current time keyboard shortcut | jbwenu | Excel | 2 | 02-05-2013 06:56 AM |
| Need To Compare Two Worksheets, Update Current Records And Insert New | David92595 | Excel | 1 | 07-20-2012 07:00 AM |
 How to insert current date into default filename ?
|
czomberzdaniela | Word | 1 | 12-27-2011 07:18 PM |
|
create check box
|
jsherman | Word | 3 | 11-08-2011 02:54 PM |
|
Auto insert current month's name and current year
|
Styler001 | Word | 4 | 01-25-2010 06:40 PM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
