AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Defaulting excel entry date to /25
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
PTurgeon
Posted 1/9/2026 16:53 (#11503429 - in reply to #11503421)
Subject: RE: Defaulting excel entry date to /25


Quebec		I haven't written anything in vba in over 15 years at this point. I don't even know if Windows still runs classic vba anymore!

Edit: I couldn't help myself. I think the following would* work in vba:

Sub AppendYearToA()
Columns("B").Formula = "=A1&""/25"""
End Sub

* I am very rusty and it assumes that classic vba still runs/is a thing

Edited by PTurgeon 1/9/2026 17:06
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)