Forum Discussion

Copper Contributor

Mar 31, 2018

Solved

How to create date stamp by using command box on multiple selected cells ?

Hi. I’m a beginner to Macro & VBA . I want to create a date stamp by using ActiveX Command box, which should work in such a way that when I selected multiple cells, the date should be appear when I c...

Macros & VBA

Need Help

Matt Mickle
Mar 31, 2018
Try linking this simple macro to your command button:

Sub Test() Selection.Value = Format(Now(), "MM/DD/YYYY hh:mm") End Sub

Matt Mickle

Bronze Contributor

Mar 31, 2018

Try linking this simple macro to your command button:

Sub Test()
    Selection.Value = Format(Now(), "MM/DD/YYYY hh:mm")
End Sub

Rose G

Copper Contributor

Mar 31, 2018

Thanks a lot; it is working as i expected. I appreciate your help

Matt Mickle
Bronze Contributor
Mar 31, 2018
You're welcome! Always happy to help.