Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2nd Post - Cannot select day on Calendar if ValueIsNull is True
I've created a user form with Calendar Control 9. All but one thing appears
to work fine. If I set the ValueIsNull property to True, I cannot select the day corresponding to the original Value property (even though it is blank when ValueIsNull is True). After selecting some other day & then back it works fine. For example: I created the control on my form today, so by default the Value property was 4/1/2005 & ValueIsNull was False. I then changed the ValueIsNull property to false, which clears the Value property. When I run the form, I cannot select 4/1/2005 without first selecting some other date. Windows XP, Office 2003 Pro, Visual Basic 6, Calendar Control 9 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2nd Post - Cannot select day on Calendar if ValueIsNull is True
Hi sivadd,
why dont you set the value by code? Private Sub UserForm_Initialize() Calendar1.Value = Now End Sub regards, ste |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2nd Post - Cannot select day on Calendar if ValueIsNull is Tru
I guess I should.
Clearly I was overthinking the problem! Thank You! "ste" wrote: Hi sivadd, why dont you set the value by code? Private Sub UserForm_Initialize() Calendar1.Value = Now End Sub regards, ste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel can you randomly select lines from another tab to post? | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
please post a 2006 calendar iin excel format. thank you. | Excel Discussion (Misc queries) | |||
Cannot select day on Calendar if ValueIsNull is True | Excel Programming | |||
Select an array of cells and paste to separate worksheet - 2nd post - 1st didn't work!! | Excel Programming |