Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The below code (supplied by Ron de Bruin) is working fine, except for
the following: When in Design Mode I see the Full month Calendar (Sunday - Saturday), but When I exit out of Design mode and click on cell B10 say, I only see Sunday thru Friday (Saturday is truncated). I've tried back in Design mode Increasing the width, but without success. How can I modify to be able To view the fully needed width? TIA, Jim May Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' Data starts on Row 7 If Target.Row = 6 Then Select Case Target.Column Case 2 'applies to Column B Calendar7.Left = Target.Left + Target.Width - Calendar7.Width Calendar7.Top = Target.Top + Target.Height Calendar7.Visible = True Case Else: If Calendar7.Visible Then Calendar7.Visible = False End Select Else: If Calendar7.Visible Then Calendar7.Visible = False End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calendar control size trouble! | Excel Worksheet Functions | |||
Calendar control font size | Excel Discussion (Misc queries) | |||
Modify Yearly Calendar to Monthly Calendar Excel 2000? | Excel Programming | |||
Control disappeared problem - specifically, the Calendar Control | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |