![]() |
#4
|
||||
|
||||
![]()
So why not simply pass the RGB value as a long? That's what the code in https://www.msofficeforums.com/148862-post9.html does via:
Const w As Long = RGB(255, 255, 255) and: s = RGB(198, 217, 241) for example. Regardless, even if you want to pass the rgb values as a string, you don't need the array. You could, for example, use: Code:
Dim r As Long, g As Long, b As Long, iLiteBlue As Long Const sLiteBlue As String = "219,229,241" r = Split(sLiteBlue, ",")(0) g = Split(sLiteBlue, ",")(1) b = Split(sLiteBlue, ",")(2) iLiteBlue = RGB(r, g, b)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
FuriousD | Word VBA | 1 | 05-12-2019 04:06 AM |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
Split word file into several PDF using the bookmarks as split positions and name | Fixxxer | Word VBA | 7 | 10-08-2018 01:10 AM |
Split function in Excel (split the screen) | Officer_Bierschnitt | Excel | 1 | 07-05-2017 07:02 AM |
![]() |
tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |