ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   KeyDown event on form (https://www.excelbanter.com/excel-discussion-misc-queries/163642-keydown-event-form.html)

Horatio J. Bilge, Jr.

KeyDown event on form
 
I have a UserForm with 2 sets of Option buttons. In the frame frmHome, I have
optHome1 and optHome2. And in frmAway I have optAway1 and optAway2.

What I want to do is set it up so when a user selects optHome1, the form
automatically selects optAway2. Likewise, optHome2 would automatically select
optAway1, and vice versa.

I tried using the KeyDown event on the form, but it doesn't seem to do
anything.
Private Sub UserForm_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If Me.optHome1.Value = True Then
Me.optAway2.Value = True
ElseIf Me.optHome2.Value = True Then
Me.optAway1.Value = True
End If
End Sub




All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com