VBA ByRef
Guide to What is VBA ByRef. We discuss how to use it to modify a variable passed to a procedure and see the changes outside the procedure with examples.
VBA Resources
VBA InStr
Guide to VBA InStr Function in Excel. Here we learn how to use the InStr function along with step by step examples & downloadable template
VBA Set Range
Guide to VBA Set Range. Here we discuss how to set the range of cells that can be used for reference through VBA code with examples.
VBA Dictionary
Guide to VBA Dictionary. Here we learn how to use Excel VBA Dictionary to create collection of key-value combinations with examples & downloadable template.
VBA ROUND Function
Guide to VBA Round Function. Here we learn how to use vba Round Function (up or down) along with examples and downloadable excel template.
VBA LCase
Guide to VBA LCase. Here we discussed how to use Excel VBA LCASE function to convert the text into lowercase with examples.