Pop up Calendar

  • I have introduced a pop up calendar in an attempt to control date input format in certain designated cells. It would be ideal if the calendar would pop up the moment that the cell is either clicked on or tabbed to. Is there any way that this can be done. At the moment I have put some validation on the cells which simply prompts the end user to press a button which has the calendar macro attached.

  • Re: Pop up Calendar


    Hi


    You could use the double click event for the worksheet to triger the macro.


    This way if there are only a few fixed cells that need the date input you could check their addresses and then run the macro or simply have the calendar pop up on all d-clicks.

  • Re: Pop up Calendar


    What calendar are you using ? I posted an example in Hey Thats Cool!of an addin that you call from the right click menu.

  • Re: Pop up Calendar


    Try this

    Code
    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
        If Not Intersect(ActiveCell, Range("D20")) Is Nothing Then
            Calendar.Show
        End If
    End Sub

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!