Restricting Date Picker Calender Control in Excel 2013 to just one column and total row

Asked Oct 17 '13 at 06:52

Active Feb 25 '15 at 21:30

Viewed 2,914 times

i am working on Office 2013 x64 and the problem i faced was date picker. i searched the net and stackoverflow too and came across Calender Control! i used the macro using vba provided by them in version 5 and it works in whole worksheet where i applied the macro, but my objective is to use this macro in only one column.Here are the lines

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

'If IsDate(Target.Cells(1, 1).Value) Then
    Set DatePickerForm.Target = Target.Cells(1, 1)
    DatePickerForm.Show vbModal
    Cancel = True
'End If

End Sub

i am finding a way to restrict macro to just one column but can't find success with code I want to use this date picker tool in only A columns and A rows so please help me, you can download xlsm file here which is a date control macro Download .xlsm file!

edited Jul 09 '18 at 18:41

Community

asked Oct 17 '13 at 06:52

Sachin Kanungo

1,054
9
17

have you tried something like: `If Target.Row = 1 and Target.Column = 1 Then...Show the data picker...`? – Kazimierz Jawor Oct 17 '13 at 06:57
Why do you need complicated code (calendar control class) for such a simple thing ;) You might want to see [THIS](http://stackoverflow.com/questions/12012206/formatting-mm-dd-yyyy-dates-in-textbox-in-vba/12013961#12013961) – Siddharth Rout Oct 17 '13 at 06:59
@KazJaw Yup i tried but excel stop responding whenever i double click..thanks – Sachin Kanungo Oct 17 '13 at 07:16
@SiddharthRout : thanks i am working with it..will see now – Sachin Kanungo Oct 17 '13 at 07:17

Restricting Date Picker Calender Control in Excel 2013 to just one column and total row

0 Answers0