Results 1 to 4 of 4

Popup Calendar gets smaller every use

Threaded View

  1. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Popup Calendar gets smaller every use

    You could change your code adding the lines shown in bold:
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
        If Target.Cells.Count > 1 Then Exit Sub
        If Not Application.Intersect(Range("c2,c17,c21,c23,c26,c29,c32,c35,c38"), Target) Is Nothing Then
            Calendar1.Left = Target.Left + Target.Width - Calendar1.Width
            Calendar1.Top = Target.Top + Target.Height
            Calendar1.Width = 190
            Calendar1.Height = 115
            Calendar1.Visible = True
            If Not IsDate(Target.Value) Then
                Calendar1.Value = Date
            Else
                Calendar1.Value = Target.Value
            End If
        ElseIf Calendar1.Visible Then Calendar1.Visible = False
        End If
    End Sub
    Attached Files Attached Files

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