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

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.

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

Hi JLE

Try this
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JLE" wrote in message ...
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.

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

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?

"Ron de Bruin" wrote:

Hi JLE

Try this
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JLE" wrote in message ...
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.

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

You can add this event Paul

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Paul Dennis" wrote in message ...
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?

"Ron de Bruin" wrote:

Hi JLE

Try this
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JLE" wrote in message ...
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.

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

Is it possible to default the calendar to today, or if not this month / year ?

"Ron de Bruin" wrote:

You can add this event Paul

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Paul Dennis" wrote in message ...
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?

"Ron de Bruin" wrote:

Hi JLE

Try this
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JLE" wrote in message ...
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.

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

Sorted - thx
Calendar1.Value = Date


"Paul Dennis" wrote:

Is it possible to default the calendar to today, or if not this month / year ?

"Ron de Bruin" wrote:

You can add this event Paul

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Paul Dennis" wrote in message ...
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?

"Ron de Bruin" wrote:

Hi JLE

Try this
http://www.rondebruin.nl/calendar.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JLE" wrote in message ...
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.