Create check box to insert current time

		Microsoft Office Forums > Microsoft Excel > Excel
Create check box to insert current time

FAQ

Thread Tools

Display Modes

12-07-2014, 07:52 PM

Tuph

Windows XP Create check box to insert current time

Office 2010 32bit

Advanced Beginner

Join Date: Dec 2014

Location: Melbourne, Australia

Posts: 31

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:46 AM.