ExcelBanter - How do I extract the date from calendarcontrol 11.0 in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I extract the date from calendarcontrol 11.0 in Excel? (https://www.excelbanter.com/excel-programming/329446-how-do-i-extract-date-calendarcontrol-11-0-excel.html)

Jacques

How do I extract the date from calendarcontrol 11.0 in Excel?

Could anybody help?

Mike Fogleman

How do I extract the date from calendarcontrol 11.0 in Excel?

ActiveCell.NumberFormat = "m/d/yyyy"
ActiveCell = Calendar1.Value

Is this what you want?
Mike F
"Jacques" wrote in message
...
Could anybody help?

Jacques

How do I extract the date from calendarcontrol 11.0 in Excel?

I did what you suggest but ActiveCell returns #Name?
ANy hint?

"Mike Fogleman" wrote:

ActiveCell.NumberFormat = "m/d/yyyy"
ActiveCell = Calendar1.Value

Is this what you want?
Mike F
"Jacques" wrote in message
...
Could anybody help?

All times are GMT +1. The time now is 04:22 AM.