+ Reply to Thread
Results 1 to 1 of 1

shrinking pop up calendar

  1. #1
    Registered User
    Join Date
    10-19-2009
    Location
    tyne & wear
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    37

    shrinking pop up calendar

    Hi All
    pop up calendar excel office 2003

    Here spreadsheet with pop up calendar in columns A 8 to A200 & G8 to G200 calendar works great till I reduce in zoom size from 100% to 85% for spreadsheet to fit screen then calendar also reduces the same but part of calendar disappears any way to stop this or enlarge calendar so all shows
    & each time I save then go back the calendar shrinks each time it's closed & saved it gets smaller till you can no longer see it have I made mistake in VBA

    the V B A

    Private Sub Calendar1_Click()
    ActiveCell.Value = CDbl(Calendar1.Value)
    ActiveCell.NumberFormat = "dd/mm/yyyy"
    ActiveCell.Select
    Calendar1.Visible = False
    End Sub

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    If Not Application.Intersect(Range("A1:A20,c1:c20"), Target) Is Nothing Then
    Calendar1.Left = Target.Left + Target.Width - Calendar1.Width
    Calendar1.Top = Target.Top + Target.Height
    Calendar1.Visible = True
    ' select Today's date in the Calendar
    Calendar1.Value = Date
    ElseIf Calendar1.Visible Then Calendar1.Visible = False
    End If
    End Sub


    please find attached
    Many thanks
    Ralph
    Attached Files Attached Files
    Last edited by hugrl; 01-20-2011 at 01:25 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1