VBA

Color Hundreds of Sheet Tabs in One Step in Different Colors

To Download the  exercise File and Follow along click Here       Here is the Code Sub ChangeColors() Dim WS As Worksheet Dim IndexColor As Long IndexColor = 50000 For Each WS In Workshe...

Extracting Records with VBA

Extracting Records with VBA Start File One of the most common tasks we do in Excel is to extract records based upon conditions we specify. In this post I show you 2 different methods to extract record...

Adding a Different Look To Your Interactive Dashboard

Code for Interactive Dashboard Course This code Changes the Background in 4 different colors Switch to the Visual Basic ALT + F11 Insert a Module ALT >I>M Copy and Paste the codes here below the...