excel 日期选择器_Excel日期选择器工具

excel 日期选择器

If you’d like a quick and easy way to add dates in a worksheet, you can use this handy date picker tool, from Jim Cone. It opens to the current date, and you can scroll through months and years, by using the scrollbars at the top of the date picker form.

如果您想使用一种快速简便的方法在工作表中添加日期，则可以使用Jim Cone提供的这种方便的日期选择器工具。 它会打开到当前日期，您可以使用日期选择器窗体顶部的滚动条滚动浏览月份和年份。

Just select a cell, and click the insert button, to add the date. If you hold the Shift key, and click the Insert button, it will append the date to the cell’s contents.

只需选择一个单元格，然后单击插入按钮即可添加日期。 如果按住Shift键，然后单击“插入”按钮，它将日期附加到单元格的内容上。

在工作表上创建日历 (Create Calendars on a Worksheet)

In addition to inserting the date, Jim’s date picker will also add a calendar to the worksheet – either a single month, or a full year.

除了插入日期外，Jim的日期选择器还将向工作表添加日历-单月或整年。

下载日期选择器文件 (Download the Date Picker File)

To see all the details, and to download the date picker file, please visit my Contextures website: Excel Date Picker

若要查看所有详细信息，并下载日期选择器文件，请访问我的Contextures网站： Excel日期选择器

The file is in Excel 2003 format, and contains macros, so enable macros if you want to test the file. The VBA code is unlocked, so you’ll be able to poke around in the code, and see how it works.

该文件为Excel 2003格式，包含宏，因此，如果要测试文件，请启用宏。 VBA代码已解锁，因此您可以在代码中四处浏览，并查看其工作方式。

Jim hasn’t tested the file in Excel 2013, but a quick test in that version worked fine for me.

Jim尚未在Excel 2013中测试该文件，但对该版本进行快速测试对我来说效果很好。

翻译自: https://contexturesblog.com/archives/2013/02/07/excel-date-picker-tool/

excel 日期选择器