Wyvern
Khaleesi
It is being asked to the brainiacs know - they will tell me if its possible
Thread Killer Mk X
- Thread starter qornea
- Start date
- Status
It is being asked to the brainiacs know - they will tell me if its possible
Wyvern
Khaleesi
czc
Thread Killer Mk VIII
No idea, ask anyway.
Murph
Thread Killer
No - that I know - it needs to be shall I say input based - like scan barcode > current time appears - this should obviously be variable.
- - - - - - - - - - Double Post Merged - - - - - - - - - -
This ^ Either I'm slow this morning or I'm making this far too hard for myself.
Wyvern
Khaleesi
Panamore en myprodol of Syndol of lenapain. . . .
Oh Murph - so if he wants that then the time has to go into the csv file when it gets scanned
otherwise there's no way for excel to know
and the scanner should be able to do this?
what is the make of the scanner? translucent?
AlienTaker
Whale Masseur
Ek wil huistoe gaan 
. Wayxz kom ontvoer my toe...........wanna play BF but my gpu at work is not strong enough
. Wayxz kom ontvoer my toe...........wanna play BF but my gpu at work is not strong enough 
Wenzdayz
Thread Killer Mk III
Ek het niks pyn pille by die werk nie.... het net 1 stilpane oorgehad van my handsak stash...
Wyvern
Khaleesi
Ek wil huistoe gaan
Beste wat ek kan doen, is om jou onder ons boardroom tafel weg te steek?
Voel jy so sleg bokka? Het jy toe gister meneer hammer ontmoet?
- - - - - - - - - - Double Post Merged - - - - - - - - - -
Aggeneeeeeeeeeeeeeeeeeee Ek maak deesdae seker ek het n ordentlike stash by die kantoor
Wenzdayz
Thread Killer Mk III
ooh ek het op a adcodol in my laai afgekom.... wonder hoeveel pynpille is te veel....
Hiro
New member
i feel ya pain. i get a migraine just about every other day
Syndols make me too drowsy so i normally take Empacods
matt
Local caffeine junky
Current date/time is easy "=NOW()"
To get it to appear as you scan a barcode, I would guess you would need to write a macro to trigger as text in a cell changes
czc
Thread Killer Mk VIII
And every time a new value gets added the every now() value updates. Tried a =if(ISTEXT(A1),NOW(),0)
Wyvern
Khaleesi
Murph
Thread Killer
I did some digging and found a piece of code that does it - but only on one side (i.e. only time in not time out in a different cell)
Mephisto_Helix
Grump Squad
matt
Local caffeine junky
Here you go
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Cells(Target.Row, Target.Column + 1).Value = Now()
End If
End Sub
matt
Local caffeine junky
In fact, here, download this. You'll need to click the button to enable content, since it works with VBA script, and that'll be after the button to enable editing (because it's a download)
https://www.dropbox.com/s/58ek7c35g8wb6yw/Barcodes.xlsm
EDIT: Added a line to delete the date/time if you delete the barcode as well
Last edited:
Wenzdayz
Thread Killer Mk III
that gif gets creepier everyday...
- Status