Month auto generated in macros

    Hello all,


    I appreciate your help in a code that I can use to have the date auto generated in macros. I need it to be dynamic as the data set, I have will be updated on a monthly bases.


    Thanks in advance.

    Hi,


    Alan is 100% right ... your question remains extremely vague ...


    To give you a hint ... out of an infinite range of possibilities ...


    Code
    Sub DisplayDates()
  MsgBox "Today's Date is: " & Date
  MsgBox "Today's Month is: " & MonthName(Month(Date))
End Sub


    Do not hesitate to provide details about your objective ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

    Booga7


    Hello,


    Thanks for your reaction ...


    Does it mean you have managed to fix your problem ???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login