Forum Discussion

Rose G's avatar
Rose G
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's avatar
    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's avatar
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's avatar
    Rose G
    Copper Contributor
    Mar 31, 2018

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

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      Mar 31, 2018

      You're welcome!  Always happy to help.

Resources