VCE Stuff > VCE Computing: Data Analytics

EXCEL Static Date Stamps

(1/3) > >>

jsimmo:
Does anyone know how I can have the data entry date appear in column A once data has been entered in column B?

I want the date to be static so it doesn't refresh every day.

I have been looking at a few VB formulas on the net but none seem to work and I can't make my own.

Mao:
past this onto the VBA page for the relevant worksheet


--- Code: (VB) ---Private Sub Worksheet_Change(ByVal Target As Range) 'every time a value in any cell within the worksheet changes
     If Target.Column = 2 Then 'if the data in column B has changed
          Range("A" & Target.Row) = Date 'date will be inserted in column A in the same row
     End If
End Sub

--- End code ---

jsimmo:
FINALLY, it works! lol

Thanks heaps!! I have been testing all these other formulas and they only worked within 1 row and not the entire column.. but yours works, thanks!

Mao:
Visual Basics is worth learning =] as crap as it is [as a programming language], its seamless integration with MSEXCEL and MSACCESS is so handy, and if you get the Enterprise package that exports .exe, it's the most handy thing to have around when you want to quickly knock up a useable application [with no fuss making the GUI... the other languages are PAINFUL when it comes to GUIs]

costargh:
does anyone have any spiffy little programs they have written or applications they have made etc that can be sent and opened on any normal comp?

Id liek to see the work u guys do in IT

Navigation

[0] Message Index

[#] Next page