Hi!
I have a userform (in the form of a calendar) that I want to input a date with. It activates alright and when I click on a date it does input the date to the active cell but I cannot then click on another cell, I must close the userform and then select another cell. What I want is:
1. The form to remain visible while I select another cell to input to.
2. The input cell must be in the range named "Dates".
This is the code in the userform.
< code start >
Option Explicit
Private Sub Calendar1_Click()
ActiveCell.NumberFormat = "mm/dd/yyyy"
If ActiveCell.Address = Range("Dates") Then
ActiveCell.Value = Calendar1.Value
Else
Exit Sub
End If
End Sub
< code stop >
Any help or direction would be appreciated! Thanks!
Bookmarks