Posted to microsoft.public.excel.programming

Patrick C. Simonds Patrick C. Simonds is offline

external usenet poster

Posts: 343

Calendar Initialize

Is there any way in which this can be amended so that the date selected when
the calendar is displayed that the next Sunday is selected (unless the
current day is Sunday then I want the date to be the current date)

Private Sub UserForm_Initialize()

Calendar1 = Now()

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Userform Initialize	[email protected]	Excel Programming	4	August 7th 07 06:01 AM
UserForm initialize	Arne Hegefors	Excel Programming	8	September 8th 06 01:48 PM
userform initialize	Patrick Simonds	Excel Programming	1	August 4th 06 11:14 PM
Initialize an array	Kleev	Excel Programming	6	December 1st 05 06:09 PM
Initialize macro	Tom Jung	Excel Programming	1	October 31st 05 04:04 AM

All times are GMT +1. The time now is 08:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us