Static Check Boxes With Time Stamp

Aug 18, 2009

I have a spreadsheet in which a check box fills the corresponding cell with the value "TRUE" if checked and "False" if unchecked. I use this check box for several functions (e.g. assigning a unique ID number). One of the functions I would like to make is a time and date stamp in another column when a user checks a box.

I have perused some of the past topics on this subject and there are a few hiccups in the other fixes.

1. I can't simply set the iterations to one because this sheet also is used to calculate expenditures, fund balances, etc. I need the calculations to be ongoing.

2. I currently have a check box macro that placed a check box on a thousand rows. It may require more rows later on. I need a solution that sets up a time stamp for all of these rows, not just a macro for one row at a time.

3. I need the time stamp to be static. I need to know when entries were made. I cannot use track changes, because we will be using this data to measure the effectiveness of our process. I need to be able to add and subtract the time between the timestamps.

View 10 Replies


ADVERTISEMENT

Static Time Stamp For Active Cell

Oct 5, 2006

I need VBA code for a time stamp. I just need code that will allow me to have a time stamp inserted in the current cell.

View 2 Replies View Related

Static Date Stamp: Add A Date Stamp That Will Populate A Field When Text Is Entered Into Another Cell

Jun 28, 2007

How can I add a date stamp that will populate a field when text is entered into another cell but will not change every time I re-open the sheet. I have been using =if(B4="",NOW()) which changes each time though and as soon as text is entered it disappears. I want to capture the actual date that someone enters text into a cell and save that date in another cell???

View 5 Replies View Related

Static Date Stamp Input From Two Cells

Jul 7, 2009

I needed a static date stamp to be entered into cell H3 when a "1" was entered into cell E3. This is the formula I found, it works fine too.

Formula for cell H3.....IF(E3="","",IF(H3="",NOW(),H3))

However, what I need to do is static date stamp the same cell, H3 but when a "1" is entered into EITHER E3 or F3

View 9 Replies View Related

Static Date Stamp Certains Cell Changes

Feb 14, 2008

I belive i have a simple date stamp problem, but i do not know the correct VBA to edit the code posted below. I would like to have a datestamp placed in an adjacent cell based upon a particular value. For instance, If Cancel is entered into cell a2, then b2 would gave the date stamp. or if Started was entered into a2, then c2 would have the date stamp.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
With Target(1, 2)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub

View 3 Replies View Related

Check Boxes Macro: Macro That Will Check If The Boxes Are Checked And If Not Ignore Them And If So Run A Certain Macro

Jul 28, 2006

I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.

View 6 Replies View Related

Check Box Date Stamp

Aug 7, 2009

I have a spreadsheet (obviously), I want to click a check box and have it date stamp with text, in the next available cell... if you know what i mean! I have attached a screenshot of what i have (the check boxes) and what i need (the writing in blue).

View 7 Replies View Related

Time Stamp Macro Tell Total Elapsed Time From When I Started To When I Finished

May 22, 2009

I am not sure that I can do this, but here is what I would like to do. I have a worksheet that I initial when I start a job in on cell and then when I finish in another cell. What I's like is to have a macro running in the back ground that will tell me the total elapsed time from when I started to when I finished.

View 5 Replies View Related

Create A Time Stamp That Shows Elapsed Time

Jan 25, 2010

I am trying to create a time stamp that shows elapsed time. So I enter my start time, and if I enter any text in cell B7, return the elapsed time in A7 based off of start time in A6. I have attached an example workbook.

View 2 Replies View Related

Adding Time More Than 24 Hours To Date Time Stamp?

May 30, 2012

I want to add hours to a date-time cell to get result in date-time.

Format of cell A1 is d/m/yy h:mm AM/PM
Format of cell A2 is General
Format of cell A3 is d/m/yy h:mm AM/PM

I want to add A2 (number of hours) to A1 to give A3.

The formula I used is A3=A1+Time(A2,0,0)

The formula works perfectly fine when A2 is less than 24, but when A2 is more than 24, the date doesn't get changed.

View 6 Replies View Related

Check Box Controlling Other Check Boxes?

Jul 4, 2014

I want to have 1 check box affect 3 others in the following way: check box 1 if checked, allow check/uncheck of check boxes 2, 3, 4 if unchecked, uncheck boxes 2, 3, 4 and do not allow checking check box 1 is linked to D1 which starts with a value of false. cell E1 is if condition to have value 1 when D1 has value of true.

I have attempted to attach an example worksheet.

Test check control.xlsx

View 1 Replies View Related

Check All Check Boxes With CheckBox

Sep 9, 2007

I am creating a userform with 10 checkboxes. The first 9 checkboxes are user options. I want the 10th check box to be a "Select All" option i.e. if the 10th checkbox is checked all the other 9 options are deemed to have been selected.

The way I want the display to work is that if the 10th checkbox is ticked all other checkboxes are cleared. Also if the 10th checkbox is ticked and any of the other check boxes is selected then the 10th checkbox should be selected.

I have tried coding this up but the checkboxes don't seem to operate as desired. I placed some code on the click event for the last option button to set the vlaue for all other buttons to false. This works but the 10th check box doesn't get ticked itself. When I try to code up the other bit I get similar issues.

View 9 Replies View Related

Time Stamp When ROW Changes

Oct 3, 2008

I have an array starting at, lets say "C25" -header line Row 24- with data entry and calculations to Colume "AW25".
Each row represents a data record for a project, where different data types are used (Number & Text).
A "termination" row is set as last row.
New records are always enterd in row "25", but any row in the array is allowed to be deleted.

The number of rows can be extended or reduced, when entering/ deleting a new record (not all info are mandatory for calculations) - basic data is followed by lots of calculations for the record.
This leads to the issue that the array is dynamic regards amount of row.
To make it even more "fancy", the array can be sorted using data filter from row "25" to "last row -1".

I need to track when a record (any cell in the row) has been accessed/ modifed/ enterd last. The time stamp may only be altered when the particular record (row) is modified and NOT in case any of the cells is modified (NON-valotile)
I have foreseen to enter that date in Colum "Bxyz" of the array.
For a referrence I still have Colume "A" as "spare".
Depending on time difference I've to mark the "date" cell with conditional formating (this is an easy task I know how to do...).

Does any one has an idea how to implement such routine (sub or Function)..
Remeber, number of rows varies - up to now there are just 310 records, but will be much more in future.
Not to forget ... some of the Colums have data avalidation set...

View 10 Replies View Related

Hot Key Time Stamp W/ My Name

Jun 17, 2008

How can I make a hot key that puts todays date and my name on it so I don't have to type it over and over again?

View 9 Replies View Related

Time Stamp

May 3, 2006

I have a system of checkboxes and now I need a time stamp when the check box was marked TRUE. They ar linked to cells so the solution can be either linked to a cell or to a checkbox. Obviously I can't use Today or Now functions because they are refreshed. I found many solutions for time stamps when a change is made in a cell, but none of them worked for me. I tried altering them with no succsess. I would be very happy if the solution would apply to the whole column, not one cell and checkbox, because I have A LOT of checkboxes.

The checkboxes are in column B and I want the time( date) stamps in column C.

View 7 Replies View Related

Time Stamp Not Updating Time Value?

Apr 25, 2014

I've got a simple code that creates a new text file in which progress of the macro is logged. I wanted to add also time stamps at the end of each line, so that the user can see when a given stage of the macro finishes working.

[Code].....

And then, in various portions of the code, after certain jobs are finished, I simply add:

[Code] .....

And it all works fine, only the problem is the time stamp is not updated... So say I run the macro at 10:00 - the time stamp on each line shows (date) 10:00...

View 2 Replies View Related

Time Stamp Entries: Time At That Moment To Be Captured And Shown In Cell "B"

Aug 12, 2007

i type into any cell in row 1 i need the time at that moment to be captured and shown in cell "B". When i type into row 2, the time which i entered the data must be captured into row 2 cell "B".

View 5 Replies View Related

Time Stamp In Comments...

Nov 7, 2008

I have been able to use a time stamp code to put a date and time in a cell... I then worked out how to use this to list dates and times in the same cell (instead of replacing the cells contents)... using this

View 7 Replies View Related

Getting Time Stamp Macro

Oct 14, 2011

device a macro which should be able to provide a time stamp in Column B when the adjecent cell in Column C is updated.

i.e. If C1 is updated, B1 should get the time stamp. *& if the value in C1 is removed, then the time stamp in B1 should also be removed.

In addition to this, I would require the macro to unprotect the sheet before updating the timestamp and protecting it again after the time stamp has been enetered. further moving on to saving the sheet.

I tried to combine few updated macros to complete it bu have been unable to do so.

View 6 Replies View Related

Time And Username Stamp

Oct 21, 2011

This time stamp macro is great but I would also like to record the person who said 'Y' in the same cell as the date stamp '12:00p.m. MWatson'. The persons name should come from the Username.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range([P13], Cells(Rows.Count, "p"))) Is Nothing Then 'change your range on this line"
With ActiveSheet
If Target.Value = "Y" Then
Target.Offset(0, 1).Value = Now

[Code] ........

View 2 Replies View Related

Date & Time Stamp

Jan 11, 2007

I would like to take this VBA a step further. What I want to achieve is to date & time stamp a worksheet in cell A1 if any other cell within the sheet is altered. Below is the VBA I used today to enter the info if cell A1 is changed. Can anyone please help with my new target.

Just one more question: When a shared file is used is it possible to also enter the username of the person who's made the alteration.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
' Only look at single cell changes
If Target.Count > 1 Then Exit Sub
' Set Target Range
Set rng = Range("A1")
' Only look at that range
If Intersect(Target, rng) Is Nothing Then Exit Sub
' Action if Condition(s) are met
Target.Offset(, 1) = Format(Date, "d mmm yyyy") & " " & Format(Time, "h:mm") & " Hrs"

End Sub

View 9 Replies View Related

Date/Time Stamp

Jan 12, 2007

I can't figure out how to get a date/time stamp to show when the spreadsheet was last updated.

View 9 Replies View Related

Time & Date Stamp

Oct 9, 2008

I found the code below in a previous tread, it works great, but i need some help altering it. I have it set-up when someone puts their initials in column B the time and date inputs in column S. But it also inputs if I hit delete or clear contents when I need to clear the form. Is there a way to make it input the time and date ONLY when letters are entered in column B?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Application.EnableEvents = False
Target.Offset(0, 17).Value = Now

Application.EnableEvents = True
End If
End Sub

View 9 Replies View Related

Match Then Time Stamp

May 8, 2006

I have 2 barcode scanners on opposite ends of a conveyor. Barcode data from reader 1 inputs the data in Column A. Reader 2 will be inputting its data into J2. When J2 has data inputed, I would like to match that data to column A. On the row where the match is found, I would like to transfer a "Yes" to column H and a time/ date stamp in column I. Once this has occurred, clear the data from J2. I will have a minimum of 20 seconds between the scans on the second reader.

View 2 Replies View Related

Duplicating Time Stamp In Vba

Jan 21, 2007

The following code was supplied by Bill, but I want to do the same thing in B10:B164, where "x" is entered in B10 and the time stamp is entered in C10 & D10.
I tried copying the same script but had an Compile error message which said Ambiguous name detected: Worksheet_Change. The name of the sheet is Sheet 1 (Main)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("M10:M164 ")) Is Nothing Then 'change your range on this line"
If Target.Value = "x" Then
Target.Offset(0, 1).Value = Now
Else
Target.Offset(0, 1).Value = ""
End If
End If
End Sub

View 5 Replies View Related

Unchanging Time Stamp

May 24, 2007

I have tried several macros and different code to accomplish the following:

1. scan a 3x9 barcode via hand-held scanner to populate a cell in column A, lets say A2.
2. the scanner does this and puts the number, say "330030" there (via the forms function)
3. in column B I would like it to say the date and time of the scan
4. the macros I have used will 'sometimes' populate the date / time but when I reopen the sheet, everything changes to 'NOW'. I would like the data to not change the date.

This is for a simple inventory spreadsheet that I am building to track movement of stock.

View 9 Replies View Related

Inserting Many Check Boxes

Sep 28, 2008

I want to put (control toolbox) check boxes in each cell in a long col.

Each check box is to be linked to the cell next to it.

What is the easiest way to do this ( i dont want to have to manually change the cell each check box is linked to)

is there a way to make the linked cells progress by draging the check box, or some other way?

View 9 Replies View Related

Check Boxes In A Spreadsheet

Mar 23, 2009

is there a way to have check boxes in a spreadsheet, that when ticked add a cost to a totals cell

ie cell e5:e25 is the totals
cells d5:d25 would be the check boxes

View 9 Replies View Related

Clearing Check Boxes

Sep 23, 2006

I have 50 check boxes not on a user form, but on spreadsheet. I attached a button that says "Clear All" (meaning 'clear all checkboxes'). I can write a sub smth like

Private Sub CommandButton1_Click()
CheckBox1.Value = False
CheckBox2.Value = False
End Sub

... and so on for all 50 check boxes. Any simpler way to do this in a loop? Smth like

For i=1 To 50
Checkbox............ .Value=False
Next i

I just cannot figure out the syntax.

View 9 Replies View Related

Set All Check Boxes To False

Sep 11, 2007

I need a macro that will reset checkboxes if checked and bypass if unchecked.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved