I am trying to add a calendar control in an Excel spreadsheet. I have "Googled" it but when I try and execute my spreadsheet keeps shutting down on me or becomes non-responsive.
Can anyone guide me to a good resource for doing this.
Thanks
Rob
Hi Rob,
Can you supply a file so we can look at what you have done?
You can check this blog post which shows how to use a calendar in a form to enter a date in a cell
Phil
Dear Phil,
I have attached the Excel file which I am having trouble with. I would like to add a calendar control in columns C and D and drag it down to row 50.
As you can see the file is very slow to respond. My code that I put into VB is no longer in the file as I removed it due to the performance I was receiving.
I really appreciate the assistance, and will definitely check out the link you suggested.
Regards,
Rob
Hi Rob,
there's no file attached. After you click on 'Add files' you also need to click on 'Start Upload'.
So what is it you are trying to achieve? You want cells C1:C50 and D1:D50 to contain a date picker? That is, if you click on one of those cells, you get a calendar/date picker which allows you to choose a date which is then entered into that cell?
Phil
