setting background color programmatically

RGB color map

 

 Using colors in excel and VBA is very simple. The most used function is RGB(x, y, z). Where x is the variable for red color, y is for green and z is for blue. All variables can have values from 0 to 255, where 0 is no color and 255 is the maximum level for […]

what is nfc near field communication

What does it mean and what is NFC

 

 Does NFC icon appear on the screen of your smartphone, or are you reading the specifications of some electronic device and you do not know what is NFC and what does it mean? In few words, the abbreviation comes from Near Field Communication and is a type of RFID technology (Radio Frequency Identification). What does […]

run-macro-on-open-file

Run macro on open file event

 

 In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel and type your macro code inside the Sub Workbook_Open(). I attach a picture for you to see what I […]

microsoft-excel-vba-macro-tutorial

Excel VBA Macro

 

 This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual actions can be automated by using a macro to execute every operation that we usually did […]