Option Compare Text
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Value = "UserForm1" Then
UserForm1.Show
Cancel = True
ElseIf Target.Value = "UserForm2" Then
UserForm2.Show
Cancel = True
End If
End Sub