EXCEL Static Date Stamps

[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) [Select]

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


[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

[excal]

I have plenty, but they're not my intellectual property

But I'm working on this: Monash University eAdmissions

aidansteele has written a fair few things though...the combubulator and various other things

He also does this in his spare time: Komodo CMS

[excal]

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]

They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).

Also, object orientation would be nice...

I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family )

[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]

They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).

Also, object orientation would be nice...

I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family )

i reckon, haha

but then, i suppose its a compromise between power and efficiency. VBA imo is very light-weight. if they decide to upgrade it to VB.NET, i think it'll chew up a fair bit more system resources, considering that the MSOFFICE application is already running. In terms of productivity, i don't think that's a good sacrafice, since the scripts need not be so complicated in VBA. [with that said, automatic formatting would be nice... it's so confusing xD]

[Mao]

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

here's something i knocked up to decipher this thread
nothing flash, if you aren't careful it'll throw errors at you

[excal]

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]

They seriously need to update the language, the syntax is still very much VB5 (VB, on the other hand, has advnaced 3 or 4 versions).

Also, object orientation would be nice...

I've heard of VSTA, but I'm not sure what the implication that has in terms of programming. If only I could then use C#...I would be in heaven (it's the least evil child of the .NET family )

i reckon, haha

but then, i suppose its a compromise between power and efficiency. VBA imo is very light-weight. if they decide to upgrade it to VB.NET, i think it'll chew up a fair bit more system resources, considering that the MSOFFICE application is already running. In terms of productivity, i don't think that's a good sacrafice, since the scripts need not be so complicated in VBA. [with that said, automatic formatting would be nice... it's so confusing xD]

TBH, I spend more time trying to get to gripes with the quirks in VBA syntax that it wouldn't matter anyway.

VB.net is still fairly lightweight, and more people would know VB.net over VB5/VBA. I mean...there's worse out there *looks at Java*

[jsimmo]

Hey, The date stamps were working yesterday, but when I try to enter data in column B today the date doesn't appear in column A?

[Mao]

did you save it as a macro-enabled worksheet?

and did you allow the security to run macros?

[jsimmo]

I think so? Could you explain what I would need to do.

EDIT: Everything is fixed.