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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Hello & Welcome to the board :)

MsgBox ("Your message here") & Date

Happy to help
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
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:
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
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
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
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: !
 

Forum statistics

Threads
1,176,530
Messages
5,903,602
Members
435,037
Latest member
AnneDerks

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
Top