still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
Hi
I highlighted a name in a list box in a userform in the VBA window while I was making it.
When I go to the sheet and bring up the userform, the list box shows that i highlighted a name
How do I un-highlight it in the VBA window
Here is a short version of the macro ..if I have to add to it.
mike
I highlighted a name in a list box in a userform in the VBA window while I was making it.
When I go to the sheet and bring up the userform, the list box shows that i highlighted a name
How do I un-highlight it in the VBA window
Here is a short version of the macro ..if I have to add to it.
VBA Code:
Private Sub ListBox1_Click()
Select Case Me.ListBox1.Value
Case Is = "bob":
bob
Unload Me
Case Is = "john":
john
Me.Hide
End Select
End Sub
mike