Pookiemeister
Well-known Member
- Joined
- Jan 6, 2012
- Messages
- 626
- Office Version
- 365
- 2010
- Platform
- Windows
I either might be really tired or I am overthinking this. That being said, I have 10 Radio buttons on a userform, when the user hovers over any of them, a control tip will be displayed for each radio button selection. I only entered one option(radio) button to test the code. The route I took for this task was probably the wrong one. I really didn't want ten IF-Then states. So I chose to use the select case but I am getting Runtime error '91':
Object variable or With block variable not set.
Thank You
Object variable or With block variable not set.
Code:
Private Sub UserForm_Initialize()
Dim selection As Control
Select Case selection
Case optSlat.MouseMove = True
optSlat.ControlTipText = "Candy Line"
End Select
End Sub
Thank You
Last edited: