katana_flyer
New Member
- Joined
- Feb 19, 2020
- Messages
- 17
- Office Version
- 2013
- Platform
- Windows
I have a variable that get's it value from a cell. I would like to use that variable to assign colour to objects.... this is what I have, which doesn't work, and you pros will know exactly why I'm sure.
In cell "a1" is a string of text RGB (255,255,0)
Is it possible for ForeColor to accept it as as an RGB value, via a variable ?
Thank you....
In cell "a1" is a string of text RGB (255,255,0)
Is it possible for ForeColor to accept it as as an RGB value, via a variable ?
Thank you....
VBA Code:
Dim team1colorscheme As String
team1colorscheme = Range("a1").Value
Me.team1player1list.ForeColor = team1colorscheme