Creating a Calendar to select a date

[dpaton05]

I have an excel table with the date to be in column A. I want to make a small calendar appear and select the date from it to insert the date into the cell for each row. I found this possibly useful website, but I do not know how to implement it.

Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features) - E90E50

Excel - VBA - Formule - VBScript - matrici - regexp - espressioni regolari - grafici - chart - visual basic for application - google api chart - function - udf - dictionary - cruscotti excel - grafici semaforo - Calendar Control - Date Picker - Advanced

sites.google.com

Could someone help me please, either with this site or with a way I could get this done?

Thanks

 

[Michael M]

Simple step by step instructions here....

How to make automatic calendar in Excel

This article present how can create an automatic calendar in excel to avoid and refresh manually your worksheet, step by step. Tutorial video available.

www.excel-exercise.com

 

[dpaton05]

Thanks for the reply Michael. I am reading through it, wondering if it will work in my situation. As you have seen some of the workbooks I have sent you previously, I am trying to make the date picker apply to each new row in the table on the quote_sheet. I am trying to follow the steps to see if it might work.

I have inserted the list of months and combo box. I am trying to right click on the combo box and pick the control tab as described in the post but when I select format control, there is no control tab. Do I need to do anything to get it to appear?

The only tabs that are there when I select format control are size, protection, properties and alt text.

 

[dpaton05]

I found, I need to insert the combo box from the form controls. It does say that you need the cell link to be A1 and A2 and it says that it is important that it remains as A1/A2 as the date formula will use that. Does it matter if my list of months and years are not in column A?

 

[Michael M]

ADVERTISEMENT

If you follow the instructions....at the Create List of months section is states

Now we need to create a list of month SOMEWHERE ELSE in our worksheet

 

[dpaton05]

I read further on and it appears like this is not what I am looking for. This post describes:

Step 13: Your calendar is ready​

And THAT'S IT
Now, each time you select a month in your drop-down list, your calendar will automatically change the color of the weekend, holidays (providing your list is up to date, of course) and also hide columns as necessary.

I am trying to not get a calendar like this, but one that will appear when you select a cell, similar to this one:

..and for it to allow you to select a date and have the date inserted into the cell that was originally selected for the calendar to appear.

 

[Michael M]

ADVERTISEMENT

Ok, so you want this one...but are you on 64 bit Excel ??

How to create a drop down list calendar (date picker) in Excel?

www.extendoffice.com

 

[KevCarter]

I have an excel table with the date to be in column A. I want to make a small calendar appear and select the date from it to insert the date into the cell for each row. I found this possibly useful website, but I do not know how to implement it.

Calendar Control for All Office versions - including Office 2016 64 bit (With Advanced Features) - E90E50

Excel - VBA - Formule - VBScript - matrici - regexp - espressioni regolari - grafici - chart - visual basic for application - google api chart - function - udf - dictionary - cruscotti excel - grafici semaforo - Calendar Control - Date Picker - Advanced

sites.google.com

Could someone help me please, either with this site or with a way I could get this done?

Thanks

This add in may be exactly what you're looking for:

Excel Date Picker — Sam Radakovitz

 

[dpaton05]

It is 64 bit excel Michael and thanks Kev, but I can't find the xlStart folder with the instructions on that link.

 

[Michael M]

Dave if you need to find your XLStart folder
Open your VBA then press CTRL + G to open the immediates wndow, now copy this into the immediates window

? application.StartupPath

Then press enter. Your path to the folder will be shown