New User...from Bombay...Help with Dates in VBA !

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
hey all...

m a begineer in Microsoft Excel VBA...an intro abt myself...m an ERP Analyst in a Financial Organization...m a JCP (Java Certified Professional)...live in Bombay :cool:

Just needed some help...trying to display a msgbox when opening Excel...hmmm...it shud display today's date preceding watever text in Msgbox in a Subroutine()...tried numerous websites and even googling...but all of them have examples on calendar or userforms...plz let me know if there is a way :eek:
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Hello & Welcome to the board :)

MsgBox ("Your message here") & Date

Happy to help
 
Upvote 0
My friend...how do I put today's date as a code after my message in the Msgbox "My text here" --in the subroutine? you have answered my question but its an irrelevant answer :cry:
 
Upvote 0
I'm sorry, I dont understand your question?

Do you mean display the date with the message?

If you use the above option you will get a message box, with your message then todays date

(Try this in a routine)

Please expand further, thanks
 
Upvote 0
thanks mate...got it...u just need to mention the keyword "Date" and delimit your msg and the date with an ampersand in the subroutine ! :wink: !
 
Upvote 0

Forum statistics

Threads
1,218,888
Messages
6,145,016
Members
450,585
Latest member
airc72

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top