How to Change Background Color of Userform with VBA codes in Excel
Here in this video shows how to Change Background Color of Userform with VBA codes in Excel.
VBA Codes Uses in this Excel Workbook:
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then
UserForm1.BackColor = RGB(85, 193, 169)
CheckBox2.Value = False
CheckBox3.Value = False
End If
End Sub
Private Sub CheckBox2_Click()
If CheckBox2.Value = True Then
UserForm1.BackColor = RGB(190, 158, 99)
CheckBox1.Value = False
CheckBox3.Value = False
End If
End Sub
Private Sub CheckBox3_Click()
If CheckBox3.Value = True Then
UserForm1.BackColor = RGB(18, 87, 150)
CheckBox1.Value = False
CheckBox2.Value = False
End If
End Sub
Видео How to Change Background Color of Userform with VBA codes in Excel автора Создай Сам Себя
Видео How to Change Background Color of Userform with VBA codes in Excel автора Создай Сам Себя
Информация
11 сентября 2023 г. 21:55:05
00:12:53
Похожие видео