I wanna set a Calendar to default as NOW

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
259
I wanna set a Calendar to default as NOW

I have a Userform which has a calendar object included.
When my Userform opens, i have the code
Code:
Calendar1 = Now
, this doesnt seem to set the date as todays date. It is tomorrows?

I'm sure this is a simple fix.

Could someone help please.

Thanks & Regards
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
259

ADVERTISEMENT

Or what about Now -1

I could, and have as a fix, but that's just not right!

i wanna know the proper way, or why it's not working.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Now returns the current date&time as a decimal (ie I get 38,986.55 if I plug =NOW() into an excel cell). The date function, on the other hand, only returns the integer part of the date ie 38,986. I suspect that your calendar control therefore is rounding up the value it gets passed (or may simply be rounding it to closest integer whether greater or less than Now, depending on when you call the function).

Best regards

Richard
 

Forum statistics

Threads
1,141,629
Messages
5,707,506
Members
421,511
Latest member
mgroah1

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