How to find the dimensions in an array using Excel vba code? Here is the code to cound the array dimensions using the ubound function – tricky one.
VBA Combo box Add Items – from Excel Range or Array
November 27, 2021
VBA code to add items to Combobox Userform. Different methods to add combobox dropdown items present in a userform using the VBA code.
How to Add Leading Zeroes in Excel – for Numbers?
November 27, 2021
Learn how to add leading zeroes in Excel for numbers in cell. You can add zeroes to the display formats or to values with formula and few simple methods.
How to run VBA Macro Daily without opening Excel file autiomtically?
November 27, 2021
Steps to schedule a macro to run daily automatically with sample code & setup scripts. Try this and test run by scheduling any VBA macro run automatically
Run Macro from Another Workbook – Excel VBA
November 27, 2021
Get code snippet to run macro from another workbook using Excel VBA command. This command works like a remote control to run VBA code in remote file.
Export VCF to Excel – Converter Online – Using Google Account
November 27, 2021
Export VCF to Excel file using Google. Load Vcard file to Excel and convert them to a CSV file. This way it is easy to import the contacts to xls file.
Excel VBA Selenium Chrome – with Sample Code
November 27, 2021
Learn how to install Selenium library for Excel VBA & launch Chrome browser to extract data from Web browser. Also get latest Chromedriver for Chrome.
VBA to Change File Encoding ANSI to UTF8 – Text to Unicode
November 27, 2021
Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.
3 Different ways to View Excel Macro Code
November 27, 2021
Learn how to open VBA editor to view Excel macro code using 3 different options.
Get Sheet Object Caption and Codename
November 27, 2021
Get Excel worksheet caption & name (or Object name or Codename) using VBA Macro. This is a readonly property and cannot be renamed using code without giving access to VBA Project Model.
