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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
You can add this event Paul

Private Sub Calendar1_DblClick()
Calendar1.Visible = False
End Sub
 
Is it possible to default the calendar to today, or if not this month / year ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Picking a Date to Populate a Cell 3
Drop Down Calendar in Excel with a Default Value 1
How do I create a drop box in Excel to show a calendar? 1
Calendar drop down box 2
Populate a cell with a date using calendar pick 2
Can I set up a drop-down box with a calendar? 1
How do I insert a calendar as a drop down box? 1
can I create a drop down list to pick a date ? 3

Back
Top