How can i set the following variant to be a Tuesday on an Excel calendar

Posted to microsoft.public.excel.programming

Corey ....[_2_] Corey ....[_2_] is offline

external usenet poster

Posts: 45

How can i set the following variant to be a Tuesday on an Excel calendar

Dim DOW As Variant
UserForm2 is a Form Calendar
If UserForm2.ActiveControl < Day(DOW) Then MsgBox "Not a Tuesday"
Ctm....

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
excel calendar - list of names displayed on calendar	Brian'88	Excel Worksheet Functions	3	November 17th 06 10:31 PM
Populating an excel calendar - eg. 10x tuesday/thursday from date x	[email protected]	Links and Linking in Excel	0	September 28th 06 10:00 AM
Modify Yearly Calendar to Monthly Calendar Excel 2000?	James Cooper	Excel Programming	13	July 13th 06 11:46 PM
import calendar items from excel into outlook calendar	jsewaiseh	Excel Discussion (Misc queries)	0	September 2nd 05 03:53 PM
Need to create a monthly calendar with Tuesday starting the week off	Joeal	Excel Programming	2	November 19th 04 11:05 PM

All times are GMT +1. The time now is 06:25 AM.

About Us