Excel-VBA Solutions

Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

How to use RGB color system

These two colors give professional look to your excel sheet.

 Range("D2").Interior.color = RGB(245, 245, 245) 'white smoke
 Range("D3").Interior.color = RGB(220, 220, 220) 'gainsboro 

white color can obtained by below RGB value
 Range("D4").Interior.color = RGB(255,255,255) 'white color

 Black color can be obtained by below RGB value
 Range("D4").Interior.color = RGB(0,0,0) 'black color

Contact Form

Name

Email *

Message *