Does anyone know to add a calendar drop down for all cells in a particular column?

  • Thread starter Thread starter mp
  • Start date Start date
M

mp

Does anyone know to add a calendar drop down for all cells in a
particular column?
 
Thanks Ron. That worked, but I would like the calendar to disappear
after I click on a calendar day. Do you know how to do that? Thanks
again.
 
You can use this

Private Sub Calendar1_Click()
ActiveCell.Value = CDbl(Calendar1.Value)
ActiveCell.NumberFormat = "mm/dd/yyyy"
ActiveCell.Select
Calendar1.Visible = False
End Sub
 
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

Drop Down List 2
Data Validation and drop-down list using IF, AND and what else? 8
Drop down menu 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Add cells in a column where other cells equal a value 3
Using a drop-down box to sort data based on seperate columns 2
Drop-down list and error message 1
Excel Excel: How do I put a formula in a drop down list 11

Back
Top