Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'm having difficulty with the calendar.value method in a userform that's being used for "beginning and ending dates". I've tried two ways to run the calendar. The first was to include the calendar control, which I got from rondebruin.nl , in a userform where it pops up when a button on the same userform is clicked and I tried another way by creating a separate userform just for the calendar. The dates will be initially posted to the startup userform and later put into a spreadsheet form for printing. When I do anything programmatically, e.g., setting the calendar.value, retrieving the calendar.value.etc, I get a runtime error telling me that the method has failed. I can load the calendar userform with no problems but everytime I get to a line such as Private Sub Calendar1_Click() StmtDtBegButton.Visible = False BegDtTxt.Value = Format("BegDtTxt.Value", "mm/dd/yy") BegDtTxt.Value = Calendar1.Value '<<<<<< Unload BegDtCal BegDtTxt.Visible = True End Sub The runtime error "-2147319765 (8002802b) : Method 'Value' of object '_DMsacal70' failed" pops up. Also, if it's any help, I am not able to change any property values for the calender such as "Day Font" or "Grid Font" without getting an error msg "Object library invalid or contains references to object definitions that could not be found". I can get into the "Custom Property Page", change the tab and visible methods. I'm out of ideas on this end. Could use some help. Thx...JG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2002 SUM with a twist... | Excel Worksheet Functions | |||
XL2002 - I'm having a bad day! | Excel Programming | |||
xl2002 problem | Excel Programming | |||
Need help writing a filtering routine | Excel Programming | |||
Using min and max function XL2002 | Excel Worksheet Functions |