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 to scroll long time to have the 1963 display

Plz help
Bakar

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

On Sat, 17 Nov 2012 15:19:07 +0100, Claus Busch
wrote:

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


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.

Thanks Very much this is great help