maverick93
New Member
- Joined
- Jan 7, 2010
- Messages
- 23
I am wondering if there is a way to create Userforms1.Frame1.backcolor that alternates between two colors until one of the optionbuttons inside the frame are selected. I have a piece of code that obviously is incorrect but i think that it illustrates what i'm trying to do.
Thanks for the help
Thanks for the help
VBA Code:
Private Sub UserForm_Activate()
If OptionButton1.Value = True Or OptionButton2.Value = True Or OptionButton3.Value = True Then
Frame1.BackColor = &HFFFF&
Else
Frame1.BackColor = &HFF&
'Change to this color after a couple seconds
Frame1.BackColor = &HFFFF&
' Change back to the original color after a couple of seconds
'loop until optionbutton 1,2,or 3 is selected
End If
end sub