PDA

View Full Version : Date picker



MahmoudHelmy
04-02-2016, 05:42 AM
I try to make Date picker in excel 2013 but I cannot Make download Microsoft Date and Time Picker Control So I search the internet and Make download to the attached file and by Make double click to any cell it open the date picker and I try to Make button click to run it but I cannot SO I need help in My click button which Make me can run the date picker.
15802

Paul_Hossler
04-02-2016, 06:29 AM
I went to the site in the comments in the class module:



'###############################################################
'# Team authors: #
'# Krisztina Szabó #
'# Gábor Madács #
'# Roberto Mensa (nick r) #
'# https://sites.google.com/site/e90e50/calendar-control-class
'###############################################################





and downloaded Calendar_Class_v1.0.6.xlsm which is more complete than the sample.xlsm you loaded

The macro to show the userform is tied to the picture of the calendar on the worksheet

The actual macro is:



Sub lancia()
TestForm.Show
End Sub

MahmoudHelmy
04-02-2016, 11:01 AM
Dear Paul,
Thanks For your reply and I make download For the attached file and when I run the macro it open Test cCalendar Class which make me can edit on it, But I need to make button which can make me run the macro and choose specific date which it put it in cell automatic.