Excel vba tips & tricks

Excel vba tips & tricks Excel VBA - Information, Tutorials, Examples & Resources Excel VBA allows you to automate various act

06/09/2020

VBA Code to Get Local IP Address

Public Function getMyIP()
'Related Reference - Microsoft WMI Scripting V1.2 Library (wbemdisp.TLB)
'Define Variable Data Types
Dim objWMI As Object
Dim objQuery As Object
Dim objQueryItem As Object
Dim vIpAddress

'Create WMI Object
Set objWMI = GetObject("winmgmts:\\.\root\cimv2")

'Query WMI
Set objQuery = objWMI.ExecQuery("Select * from Win32_NetworkAdapterConfiguration Where IPEnabled = True")

'Loop Thru all assigned IP Addresses
For Each objQueryItem In objQuery
Debug.Print vbCrLf & "All Assigned IP Addresses"
For Each vIpAddress In objQueryItem.ipaddress
Debug.Print "User IP - " & vIpAddress
Next
Next

End Function

Press F5 to run the code. You can view the results in the immediate window (Ctrl + G).

9 quick tips to improve your VBA macro performance. Tip 1 : Turn off everything but the essentials in VBAOne of the...
23/08/2020

9 quick tips to improve your VBA macro performance.



Tip 1 :

Turn off everything but the essentials in VBA
One of the first things to do when speeding up VBA code is to turn off unnecessary features such as animations, screen updating, automatic calculations, and events while your macro is running. These features can add extra overhead and slow down the macro, particularly if the macro is modifying many cells and triggering lots of screen updates and recalculations.

The below code sample shows you how to enable/disable:

09/08/2020

Excel Keyboard Shortcuts to Convert Numbers to Text, Ignore Errors, and Pate Values :) Video Credit goes to

08/08/2020

"MkDir" VBA Function Make folders and subfolders using excel VBA Macros.

08/08/2020

Doesn't matter what you do in life, learn Microsoft excel!!

VBA Macro - Tips of the day !!
03/08/2020

VBA Macro - Tips of the day !!

Anyone else had a chance to try out the new =CAKE function in Excel?
03/08/2020

Anyone else had a chance to try out the new =CAKE function in Excel?

02/08/2020

We've got 5 things for you...and they're all charts you didn't know you could make in . Winking face

02/08/2020

Need to streamline data and help make your sheets easier to work with? Try organizing your items into drop-down lists, here's how. Down pointing backhand index

Address

Delhi
110053

Website

Alerts

Be the first to know and let us send you an email when Excel vba tips & tricks posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category