Office tutorials

Description of mathematical functions in Excel VBA Below are the names and descriptions of all standard math functions in Excel VBA. As you can see functions such as RND () do not require arguments. Functions such as ROUND () require 2 arguments – the value and the number of decimal places to which we round our value. Numbers with decimal places in […]

Read More

InputBox window – entering data into VBA It’s great, that you have already reached this part of VBA tutorial. After the VBA MsgBox window you will learn how to work with window for entering data into our VB code. Like the MsgBox window, this window has many additional parameters. Let’s try to create a simple […]

Read More

1. How to extract day, month, year, weekday and quarter from date in Excel? If you are reading this article, you would probably like to use the date and time function in Excel. Excel has built-in sheet functions to help you calculate and extract date parts from the date. At the beginning, you should make sure that our […]

Read More