Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) |