Monthly view calendar

[Bakar]

Hi Everyone
I have a userform with a calendar
Its working fine only problem
When I call the userform the default calendar view is this month
Can I have an input box to search example year 1963 otherwise I have t
scroll long time to have the 1963 display

Plz help
Baka

 

[Claus Busch]

Hi Bakar,

Am Sat, 17 Nov 2012 13:32:43 +0000 schrieb Bakar:

I have a userform with a calendar
Its working fine only problem
When I call the userform the default calendar view is this month
Can I have an input box to search example year 1963 otherwise I have to
scroll long time to have the 1963 display

e.g. write your date in C1 and copy following code in code module of the
UserForm:

Private Sub MonthView1_Click()
MonthView1 = Range("C1")
End Sub

If you click on the MonthView the date change to C1 value


Regards
Claus Busch

 

[Bakar]

Hi Everyone
I have a userform with a calendar
Its working fine only problem
When I call the userform the default calendar view is this month
Can I have an input box to search example year 1963 otherwise I have t
scroll long time to have the 1963 display

Plz help
Bakar

Thanks Very much this is great hel

 

[CellShocked]

Hi Bakar,

Am Sat, 17 Nov 2012 13:32:43 +0000 schrieb Bakar:


e.g. write your date in C1 and copy following code in code module of the
UserForm:

Private Sub MonthView1_Click()
MonthView1 = Range("C1")
End Sub

If you click on the MonthView the date change to C1 value


Regards
Claus Busch

I made a list of years (quite imperfect) named it as a named range, and
made reference to it in a cell as selection drop-down. Then refer to the
contents of that cell in a formula breakdown/concatenation to compile the
final date value to express the calendar in. No code change other then
the bits which concatenates the date value from the drop-down selection,
if even that (concatenation)is needed.

If the calendar is made right, it could be formatted to show whatever
month for whatever year is entered into a certain cell. Then, the
drop-down list or date range validation makes it mouse click pick.