S Oberlander
Board Regular
- Joined
- Nov 25, 2020
- Messages
- 147
- Office Version
- 365
- Platform
- Windows
So the user selects something that does not have a valid result. I give an error message "Try again!" and now the userform needs to pop back up.
I've done this in the past, I don't know why now I am getting Run-time error 438: Object does not support this property or method.
I've done this in the past, I don't know why now I am getting Run-time error 438: Object does not support this property or method.
VBA Code:
Private Sub Calculate_Click()
Unload Me
Select Case True
Case a
'do a
Case b
'do b
Case c
'do c
Case Else
MsgBox "Try again"
IQMPossibilities.show 'code stops here
Exit Sub
End Select
End Sub