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

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

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,141,756
Messages
5,708,333
Members
421,566
Latest member
7Nabisco

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