ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calendar Control (https://www.excelbanter.com/excel-programming/393979-calendar-control.html)

Jim[_69_]

Calendar Control
 
I've used mscal.ocx to create a calendar control on a user form - However
the calendar gets larger each time I use it
How can I prevent this ?

Regards & TIA



Jim[_69_]

Calendar Control
 
Thanks for the tip ... I've done that but somehow feel that it shouldn't be
necessary

"merjet" wrote in message
ups.com...
Try fixing the size when the UserForm is activated like this.

Private Sub UserForm_Activate()
Calendar1.Height = 120
Calendar1.Width = 180
End Sub

Hth,
Merjet






All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com