Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can i set the following variant to be a Tuesday on an Excel calendar
Interesting out come for me.
Found that no matter what format i tried with the textbox, i could not revert it from "mm dd yyy" to "dd mm yyy", So i tried replacing the textbox with a label, and found the label instantly displayed the date in a "dd mm yyy" format. The dishes are now doen with this topic. Now where is that next problem going to come from .... "Corey ...." wrote in message ... Dim DOW As Variant UserForm2 is a Form Calendar If UserForm2.ActiveControl < Day(DOW) Then MsgBox "Not a Tuesday" Ctm.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel calendar - list of names displayed on calendar | Excel Worksheet Functions | |||
Populating an excel calendar - eg. 10x tuesday/thursday from date x | Links and Linking in Excel | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) | |||
Need to create a monthly calendar with Tuesday starting the week off | Excel Programming |