Daily Archives: September 4, 2020

Last Updated on January 11, 2023 by token 1. Now VBA function – Description The Now VBA function   returns the current date and time or the time only. If we want Excel VBA to return the current date, we should use this function. The Date function has no arguments. The […]

Last Updated on January 11, 2023 by token 1. MonthName VBA Function – Description The MonthName VBA function  returns the word name of the month from 1 to 12. It is important that the argument for this function is a number, not a date. The function can be combined with […]

Last Updated on January 11, 2023 by token 1. Month VBA function – Description The Month VBA function returns a number representing the month of a given date. So if we want Excel VBA to return the numbers corresponding to the following months, we should use this function. It should […]

Last Updated on January 11, 2023 by token 1. Minute VBA function – Description The Minute VBA function returns a number representing the minutes for a given date and time. So if we want Excel VBA to return the numbers corresponding to the next minutes, we should use this function. […]

Last Updated on January 11, 2023 by token 1. Hour VBA function – Description The Hour VBA function   returns a number representing the hour for a given date and time. So if we want Excel VBA to return to us numbers corresponding to the following hours, we should use this […]

Last Updated on January 11, 2023 by token 1. Day VBA function – Description The Day VBA function returns a number that represents the day of the month of a given date. So if we want Excel VBA to return to us numbers corresponding to the next days of the […]

Last Updated on January 11, 2023 by token 1. VBA DateValue Function – Description The DateValue VBA function  converts a text date into a formatted VBA date. The function is also used to extract the date value itself from a date and time value. If we would like to convert […]

Last Updated on January 11, 2023 by token 1. DateSerial VBA Function – Description The DateSerial VBA function  returns a date composed of arguments such as year , month , day . If in VBA you have numbers representing year, month, day and you want to compose a date from […]

Last Updated on January 11, 2023 by token 1. DatePart VBA function – Description The DatePart VBA function  returns the individual parts of the date and time depending on the arguments entered. With its help, we can extract elements such as quarter, day of the year, week of the year, […]

Last Updated on January 11, 2023 by token 1. DateDiff VBA function – Description The DateDiff VBA function  returns the difference between two dates. Depending on what we introduce in the function arguments, we can get the difference in days, months, years, weeks, quarters, hours, minutes, seconds, etc. Monday. In […]

Last Updated on January 11, 2023 by token 1. DateAdd VBA function – Description DateAdd VBA function is the date or time plus or minus a specified number of time units. So if we want to enlarge the date by e.g. a certain number of days, months and years, we […]

Last Updated on January 11, 2023 by token 1. Date VBA function – Description The Date VBA function   returns the current date. If we want Excel VBA to return the current date, we should use this function. The Date function has no arguments. The date value from the Date function […]

Last Updated on January 11, 2023 by token 1. Val VBA function – Description The Val VBA function   searches for occurrences of numbers in a string. If a number appears at the beginning of a string, the function returns its value in the form of a number with the Double […]

Last Updated on January 11, 2023 by token 1. UCase VBA function – Description UCase VBA function converts all letters in a string to uppercase. You can compare it to the CAPITAL function in an Excel worksheet. How to use UCASE function in VBA Excel? In the argument of the […]

Last Updated on January 11, 2023 by token 1. Trim VBA Function – Description The Trim VBA function removes spaces from both sides of the text. We use it when we want to remove unnecessary spaces from both the left and right side of a text string. It is worth […]

Last Updated on January 11, 2023 by token 1. StrReverse VBA Function – Description The StrReverse VBA function   returns text with characters in reverse order. If we want to reverse characters in a text string starting from the last one, we should use this function. 2. VBA Replace function – […]