What are these 2 Latest updates from WhatsApp? Not sure how many know that these 2 latest updates are available in their WhatsApp messenger latest version (2.20.13 or above) Activate Dark Mode Theme. Enable Fingerprint Scanning. Lets see how to enable these options in Your smartphone. 1. How to Activate […]
How to find your VBA Version – V6 or V7?
December 24, 2024
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?
December 24, 2024
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 […]
Enable Dark Mode in Windows 10
December 24, 2024
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
December 24, 2024
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 […]
VBA Get My Public IP Address
December 24, 2024
What is my Public IP Address? There are no direct methods to get public ip address in VBA. This has to be done by using a web service using below steps: Open IE Explorer from VBA Code. Navigate to this page -> What is my Ip? Wait for page to […]
What is my IP Address?
December 24, 2024
[show_ip] This page displays the public IP address assigned to your computer. This shows the IPV4 address. To view IPV6, open command prompt & use the command ipconfig. Along with IPV6 public IP address, this command will display even the local IP address if your computer is connected to internet […]
VBA get Path to Default Temporary folder
December 24, 2024
VBA – Find Temporary Folder Path To save any intermediate data files, instead of creating a folder, You can use system default temporary folders. This way, there is less coding effort required to manage the new folders. But, to do that, You need to first find the folder path. There may […]
Find Local IP Address – VBA Macro Code
December 24, 2024
Computer IP Address – Local & Public IP stand for Internet Protocol address. It is assigned to every network device – be in a computer, smartphone, router etc., This address is used to send the Internet data packets to the correct device attached to internet. The IP address have different […]
Excel VBA Hyperlink Follow – URL within Macro
December 24, 2024
How to Click Hyperlink in Excel with VBA Macro? There are 2 methods available to click a hyperlink in Excel. Both the methods do open the URL in the default browser or open the corresponding file in the default application. Here is the code demonstrates both methods. Sub follow_hyperlink() ‘Follow […]