xlf | GetWS2UFcolor function
GetWS2UFcolor - about the function
Description: returns the Fill color of a worksheet cell in UserForm (UF) &H hex & format 11 character format.
Syntax: GetWS2UFcolor(Reference).
Arguments: Reference (required): a WS cell.

GetWS2UFcolor - the VBA code
Code 1: Function
GetWS2UFcolor
returns the Fill color of a WS cell in UF &H...hex...& 11 character format
Function GetWS2UFcolor(Reference As Range) As String GetWS2UFcolor = "&H" & Right("000000" & Hex(Reference.Interior.Color), 8) & "&" End Function
- Development platform: Office 365 ProPlus - Excel 2016 MSO (16.0...) 64 bit
- Published: 20th May 2018
- Revised: Friday 24th of February 2023 - 02:38 PM, Pacific Time (PT)