Calendar with Current Date

[Istiyak]

i have uploaded a file on my website.


www.istiyakshaikh.hpage.com > Downloads > Calendar.xls


Kindly add the code in the file, so that calendar can popup with current date.


Control : Calendar Control 11.00

Format : Excel 2003


Any query plz let me know.


Regards

Istiyak

 

[SirJB7]

Hi, Istiyak!

Isn't it the same question as of this post?

http://chandoo.org/forums/topic/calendar-control-formula-help

If it is, please check xld comment.

Regards!

 

[Istiyak]

Hi sir

Solution is not provided.

 

[SirJB7]

Hi, Istiyak!


I have no access to a machine with 2003 version, just 2010 and a few 2007.

In those versions, go to Programmer tab, Controls group, Design Mode icon, Insert icon, choose ActiveX controls, Additional controls, and check for Microsoft Date and Time Picker Control 6.0 (SP4).

Register it, then insert it into your worksheet, and use this code for the click event to assign the current date:


-----

Sub ControlName_Click()

ControlName.Value = Int(Now())

End Sub

-----


Sorry for not being able to assist you further with older Excel versions.


Regards!

 

[Istiyak]

Still Facing Issue.


Regards

Istiyak

 

[NARAYANK991]

Hi Istiyak ,


Use this procedure instead of the one you have at present :

[pre]

Sub inputdate()
Calendar.Calendar1.Value = Date
Calendar.Show
End Sub
The line :

Calendar.Calendar1.Value = Date

[/pre]
is an addition.


Narayan