How To Using logical operators and functions in Excel
Oct 19, 2020
The three most used logical operators in Excel VBA are: And, Or and Not. As always, we will use easy examples to make things more clear.
How to using Macro Recorder in Excel
Oct 19, 2020
The Macro Recorder, a very useful tool included in Excel VBA, records every task you perform with Excel.
How To Check For Prime Numbers In Excel
Oct 18, 2020
Below we will look at a program in Excel VBA that checks whether a number is a prime number or not.
How To Get Path And Fullname In Excel
Oct 18, 2020
The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file).
How To Import Data From A Text File In Excel
Oct 18, 2020
Below we will look at a program in Excel VBA that reads data from a text file.
How to Insert and Use Option Button in Excel
Oct 18, 2020
If you have more than one option button, only one of the option buttons can be selected.
How To Protect Macro VBA Code In Excel
Oct 18, 2020
Just like you can password protect workbooks and worksheets, you can password protect a macro in Excel from being viewed (and executed).