Right_Click: I tried using your idea in the following code - I want the "second" instance if the user right clicks. I got an error saying the the "top" needs to be closed first? Any ideas?
Gene, "The Mortgage Man", Klein
Private Sub OptionButton1_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Dim f1 As New UserForm1
If Button = 1 Then
MsgBox "Your left click code goes here", , "Left button"
ElseIf Button = 2 Then
I'm not suggesting that you use the method I showed. It's just an option and usually better coding practice if you need two objects that vary little from one another. Also, I have never seen that error and would need to see more or perhaps all of the relevant code to understand what the problem is...