After VBA calendar control is finished, office without control can read it.

open an EXCEL workbook, enter a worksheet, and press "view-toolbar-control toolbox" to bring up the control toolbox.

it's not that these controls are not pre-installed and you don't have references. Add them to the control toolbox as follows: right-click on the development tool, select additional controls, and find the calendar control (microsoft date and time picker ...........................................................................................................

Inherent Constant:

In VBA, the data types of constants are integer, long integer, single precision, double precision, byte, currency, character, date and logic. An integer data is an integer constant and a long integer data is a long integer constant.

for example, 12% and -1% are integer constants, and 32768 &; 、1& Is a long integer constant, -2.5 1 and 3.14 are single-precision real constants, 3.1415926# is a double-precision real constant, China and Shanghai are character constants, #7/13/21 11:45PM# is a date constant, and the characters are enclosed by the symbol #.