How to Initialize an Array in Vba? Different methods to assign values to array are explained here. Starting from basic to few easy methods to initialize array with multiple values are discussed in here. Here are the list of available methods. Direct or a loop method. Using VBA function Array. […]
VBA – Add Items to Array – Dynamic Resize without erasing data
January 10, 2025
How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to be changed. Lets see an example: Consider you have an array like the below one: […]
How to find your VBA Version – V6 or V7?
January 10, 2025
How to find Your VBA Version? The below code will get the VBA version detail using pre-compiler directives. We cannot display the value in thee variables. But it can be used inside the #IF. Then we can print the required values. Here is the code that can fetch VBA version […]
How to enable dark mode in Firefox browser?
January 10, 2025
Firefox – Dark Mode – Desktop The night mode can be enabled in Firefox using the below option directly. Open Firefox browser Click on Settings (Burger icon on top right corner) Select ‘Customize’ Click on ‘Themes’ at footer section Choose ‘Dark’ & click done. This will change the white background […]
How to enable Google Chrome Dark Mode or Dark Theme?
January 10, 2025
How to enable Google chrome dark mode for PC/Windows or Android device browsers? These steps enable a dark background & bright text for all websites.
Enable Dark Mode in Windows 10
January 10, 2025
Activate Windows 10 Dark Mode Steps to enable dark mode in Windows 10 operating system is given below: Click Windows Start (Left bottom corner Windows icon) Select ‘Settings’ gear Choose ‘Colors’ Select ‘Dark’ under ‘Choose your color’ option Pick accent color for menus & borders Click Ok Now, system will […]
2 Ways to Enable Dark Mode in Excel – Night Mode
January 10, 2025
Activate Night Mode for Excel Here is the easy method to enable dark mode in Excel & other MS Office applications. Click ‘File’ in Menu. Select ‘Account’. Choose one of this option under ‘Office Theme’ ‘Black’ – available only for Office 365 subscribers ‘Dark Gray’ – Office 2016 Click Ok […]
[Outlook VBA] Select Appointments/Meetings Invites in Inbox
January 10, 2025
Appointment/Meeting Invites using VBA In addition to handling Emails, MS Outlook application also handles calendar appointments & meeting invites. All these items are received in your Inbox. We could identify the difference manually by seeing the icon for each item. But to identify the difference in a VBA code, we […]
[Excel Shortcut] – Copy Only Visible Cells – Autofilter – Windows/Mac
January 10, 2025
Select & Copy Only Visible Cells in Excel In Excel, a row or column may be hidden when we use auto-filter option or manually hide them. Add an auto-filter over a column or a table & Select a valid value for the filter. This action will hide few rows which […]
Validate Email Address – VBA Code – Excel
January 10, 2025
Verify Email Address Format in VBA Code in this page will verify if a email id is in proper format. This code uses regex pattern matching. To do this, first You need to define a regular expression pattern that will match a valid email id. A email id has a […]