Remalay
07-28-2006, 12:48 AM
Guys,
I've managed to stumble over the means of changing the background colour of commandbuttons on a userform within VBA coding, but am struggling to determine the logic behind the colour grading.:banghead:
Can anyone advise?
Private Sub CommandButton1_Click()
With UserForm1
.cb1.BackColor = &HFFA080
.cb2.BackColor = &HFFA8C0
.cb3.BackColor = &HFFC000
.cb4.BackColor = &HFFD000
.cb5.BackColor = &HFF0000
.Show
End With
End Sub
I've managed to stumble over the means of changing the background colour of commandbuttons on a userform within VBA coding, but am struggling to determine the logic behind the colour grading.:banghead:
Can anyone advise?
Private Sub CommandButton1_Click()
With UserForm1
.cb1.BackColor = &HFFA080
.cb2.BackColor = &HFFA8C0
.cb3.BackColor = &HFFC000
.cb4.BackColor = &HFFD000
.cb5.BackColor = &HFF0000
.Show
End With
End Sub