how do i pick A date for a cell from a drop down calendar?

J

JLE

I'm trying to set up a spreadsheet so that people can pick their dates from a
calendar, rather than retyping the date whenever it changes. Sort of a
covenience thing and it reduces errors, hopefully.
 
P

Paul Dennis

Sorry for jumping on, but is it possible to make the calendar disappear by
just clicking on a date, or double clicking rather than having to click a
different cell?
 
R

Ron de Bruin

You can add this event Paul

Private Sub Calendar1_DblClick()
Calendar1.Visible = False
End Sub
 
Top