• If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
  • Excel articles and downloadable files provided in the articles have not been reviewed by MrExcel Publishing. Please apply the provided methods / codes and open the files at your own risk. If you have any questions regarding an article, please use the Article Discussion section.
pedrowave

New Rolling Calendar Control

Excel Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
  5. 2011
  6. 2010
In old versions of Excel there was an add-in for a DatePicker Calendar Control that allowed dates to be entered into a cell from a monthly calendar.

New versions of Excel don't include a DatePicker add-in out of the box, so add-ins have been developed by third parties to fix its absence, and not all of them work in Excel of 64-bits.

I have designed a Rolling Calendar Control that works in all desktop versions of Excel, tested on Windows and pending testing on Mac, which allows you to enter dates and times using pairs of ciphers, and that you can download from my blog:

Rolling Calendar Control in Excel

It can be installed as an Excel add-in for use in all your templates.

Notice: This Calendar Control will generate a control sheet in each workbook that it is installed in and will create a form on each sheet with the calendar control form.

It is protected without a password to serve as a self-study of what can be done in Excel. I hope it is useful and above all educational.
  • ControlMenu0.gif
    ControlMenu0.gif
    12.1 KB · Views: 140
  • Control_Color.gif
    Control_Color.gif
    28.4 KB · Views: 135
  • Control_TipoFecha.gif
    Control_TipoFecha.gif
    16.1 KB · Views: 107
  • ControlMenu.gif
    ControlMenu.gif
    24.2 KB · Views: 134
Author
pedrowave
Views
4,137
First release
Last update
Rating
0.00 star(s) 0 ratings

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
Back
Top