Radio Buttons and VBA coding

[Ted]

if you run across him, and you remember this chat of ours, maybe you could
pass along this message to Gort: Klaatuu barada nikto. i think he'll
'understand'

 

[Ted]

hi and tell me if i'm wrong....in the instance of 'Case 2', if the OldValue
equals five and you've selected the button which maps to Case 2....should the
comment you put there not read 'Do whatever when it changes from 5 to 2'
since the oldvalue was a 5?


Select Case Me.opgOutcomes
Case 1
'Do stuff for 1s
Case 2
If Me.opgOutcomes.OldValue = 5 Then
'Do whatever when it changes from 2 to 5
Else
'Do something else
End If
Case 3
etc
End Select