Creating a Calendar to select a date

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,157
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.


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

Thanks
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,054
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Simple step by step instructions here....
 

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,157
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Aug 14, 2018
Messages
2,157
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Oct 27, 2005
Messages
20,054
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows

ADVERTISEMENT

If you follow the instructions....at the Create List of months section is states
Rich (BB code):
Now we need to create a list of month SOMEWHERE ELSE in our worksheet
 

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,157
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.

1606872103599.png








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

1606872216142.png


..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.
 

KevCarter

Board Regular
Joined
Dec 7, 2013
Messages
145
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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.


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

Well-known Member
Joined
Aug 14, 2018
Messages
2,157
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

Well-known Member
Joined
Oct 27, 2005
Messages
20,054
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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
Rich (BB code):
? application.StartupPath
Then press enter. Your path to the folder will be shown
 

Watch MrExcel Video

Forum statistics

Threads
1,128,089
Messages
5,628,609
Members
416,327
Latest member
Chimay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top