VBA – Timer Function
The Timer Function returns the number of seconds and milliseconds since 12:00 AM. Syntax Timer() Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox("Time is :…
VBA
VBA – Time Function
The Time Function returns the current system time. Syntax Time() Example Private Sub Constant_demo_Click() msgbox("Line 1: " & Time()) End Sub When you execute the above function, it produces the…
VBA – Second Function
The Second Function returns a number between 0 and 59 that represents the second of the hour for the specified time stamp. Syntax Second(time) Example Add a button and add…
VBA – Minute Function
The Minute Function returns a number between 0 and 59 that represents the minute of the hour for the specified time stamp. Syntax Minute(time) Example Add a button and add…
VBA – Hour Function
The Hour Function returns a number between 0 and 23 that represents the hour of the day for the specified time stamp. Syntax Hour(time) Example Add a button and add…
VBA – Now Function
The Function Now returns the current system date and time. Syntax Now() Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim a as Variant a =…
VBA – WeekDay Name
The WeekDayName function returns the name of the weekday for the specified day. Syntax WeekdayName(weekday[,abbreviate[,firstdayofweek]]) Parameter Description Weekday − A required parameter. The number of the weekday.Toabbreviate − An optional parameter. A…
VBA – WeekDay
The WeekDay function returns an integer from 1 to 7 that represents the day of the week for the specified date. Syntax Weekday(date[,firstdayofweek]) Parameter Description Date − A required parameter. The…
VBA – Month Name
The MonthName function returns the name of the month for the specified date. Syntax MonthName(month[,toabbreviate]) Parameter Description Month − A required parameter. It specifies the number of the month.Toabbreviate − An optional…
VBA – Year Function
The Year function returns an integer that represents a year of the specified date. Syntax Year(date) Example Add a button and add the following function. Private Sub Constant_demo_Click() msgbox(Year("2013-06-30")) End…