Creating a Calendar to select a date

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,148
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
 

KevCarter

Board Regular
Joined
Dec 7, 2013
Messages
145
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
Good tip, I learned something there as well. Thank you!
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,148
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Now I have the date picker inserted but I do not know how to make the little calendar appear when I have the date field selected.

1606876086840.png
 

KevCarter

Board Regular
Joined
Dec 7, 2013
Messages
145
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Now I have the date picker inserted but I do not know how to make the little calendar appear when I have the date field selected.

View attachment 27066
I no longer use it, but if I recall, it shows automatically when you select a cell with a valid date. Is your date entered as text, or is it a valid date?
 

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,148
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I just saved it, closed and reopened my workbook and it now works as described, thankyou,
 

Watch MrExcel Video

Forum statistics

Threads
1,127,539
Messages
5,625,402
Members
416,100
Latest member
lirongr1996

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