Good day all,
Is it possible to assign a keyboard shortcut to change a userform textbox background color? If so, could you please point me in the right direction? The below code works for a textbox when assigned to a command button on the userform. However, it does not work when assigned to a keyboard shortcut.
Thanks for the help!
Is it possible to assign a keyboard shortcut to change a userform textbox background color? If so, could you please point me in the right direction? The below code works for a textbox when assigned to a command button on the userform. However, it does not work when assigned to a keyboard shortcut.
Code:
If UserForm1.TextBox1.BackColor = &HFFFFFF Then
UserForm1.TextBox1.BackColor = &HFFFF&
Else
UserForm1.TextBox1.BackColor = &HFFFFFF
End If
Thanks for the help!