How to Use Hex in VBA Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Using hexadecimal notation makes it easier to understand the numbers that certain VBA objects or properties use. One such property is color. For example, the base-10 notation "65025" doesn't reveal the three-part structure of the number, but using the hexadecimal notation for the same number, "&HFF00FF," reveals this structure: the color's red component is in the two rightmost characters, the blue component is in the two middle characters, and the green component is in the fifth and sixth characters from the right.

Advertisement

Hexadecimal Math

Video of the Day

Step 1

Click the "Developer" tab to expose the controls for working with VBA.

Video of the Day

Step 2

Click the "Visual Basic" button to enter the VBA programming environment.

Advertisement

Step 3

Paste the following program in the window at screen center. This program uses VBA's hexadecimal notation symbol, "&H," to define two variables, "a," and "b." Variable "x" holds the sum of these two numbers, and the "MsgBox" statement displays the non-hexadecimal representations of "a," "b," and "x."

Advertisement

Public Sub doHexMath() Dim x, a, b a = &H10 b = &HA x = a + b MsgBox a & " plus " & b & " equals " & x End Sub

Step 4

Click any of the program's statements to select the program.

Advertisement

Step 5

Click the "Run" menu's "Run" command. Excel will display the message "16 plus 10 equals 26." In hexadecimal, "10" equals 16, and "A" equals 10.

Set Colors

Step 1

Click the "Developer" tab, then click the "Visual Basic" button on the "Code" panel. This action will bring up the VBA programming environment.

Advertisement

Advertisement

Step 2

Paste the following program into the programming window that appears. This program uses hexadecimal notation to assign a background color to the currently selected cell in the workbook. That notation appears in the assignments to the variables "red," "green," and "blue." The "ActiveCell" statement also uses hexadecimal notation, and adds the "red," "green," and "blue" components together to yield a number in the format needed to set colors in Excel. Notice that only the "red" variable is non-zero. This means that the color you'll see will be pure red.

Advertisement

Public Sub colorCell() Dim blue, green, red red = &HFF green = &H0 blue = &H0 ActiveCell.Interior.Color = blue * &HFF00 + green * &HFF + red End Sub

Step 3

Click any statement in the program to select the program for execution.

Advertisement

Step 4

Click the "Run" menu's "Run" command to execute the program.

Step 5

Click the "Excel" icon in the Windows taskbar to return to Excel. Notice that the current cell has the red color you specified in step 2.

Advertisement

Advertisement

Report an Issue

screenshot of the current page

Screenshot loading...