Last Updated on January 11, 2023 by token VBA IF THEN ELSE – What is the conditional statement? In the simplest sense, VBA IF is the equivalent of the Excel IF(), but function used in the VBA code. Imagine that you want your program to make decisions based on the data […]
Daily Archives: June 24, 2018
5 posts
Last Updated on January 11, 2023 by token Worksheet functions – How to use the Excel function in VBA Have you ever wondered how you can use the Excel function in VBA? Worksheet functions come with help. As you know, the Excel spreadsheet offers a number of useful functions. The resource of functions […]
Last Updated on January 11, 2023 by token Creating VBA functions defined by user Both Excel and VBA offer you a number of useful functions. But what if you would like to create a VBA function that you will use in Excel? VBA offers you possibility of creating your own functions. These are […]
Last Updated on January 11, 2023 by token Description of date and time functions. VBA date functions, as the name suggests, are used to manipulate the values related to dates and time. On their basis, you can catch any parameter such as day, month, year, etc. from the given date. […]
Last Updated on February 8, 2023 by token VBA character functions in Excel The Excel VBA offers us a number of useful character functions. We can’t compare them to the number of functions in an Excel spreadsheet, and these are not the same functions. The use of the sheet functions in VBA code […]