LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Select None in dropdown calendar Excel 2003 Sammy New Users to Excel 1 November 13th 09 11:10 AM
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 LunaMoon Excel Discussion (Misc queries) 9 July 29th 08 12:28 AM
Can I put a calendar in a drop down list to select a date? goldsie2003 Excel Discussion (Misc queries) 1 January 23rd 06 11:49 AM
Cant select my Calendar Peter.N Excel Programming 2 February 22nd 05 05:44 PM
VBA- Calendar Control Click Event W Specific Select Case requirements Mark[_23_] Excel Programming 0 September 12th 03 06:24 PM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"