hi all

i have some code that when the user double clicks a cell in range eg h1:h174 it pops up userform 2 so user can fill cell from combo box but i would like it to check a value. for example if i had value "head" in c1 when i go cross and double click h1 i would like userfrom1 to pop up and if i enter vaule "block" in c2 and the go cross to h2 and double click cell i would like userform 2 to pop up and if i enter value "crank" in c3 and the go cross to h3 and double click cells i would like userform 3 to pop up and if i enter value "preset" in c4 and the go cross to h4 and double click cells i would like userform 3 to pop up

thanks in advance here my code:


 
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Count > 1 Then Exit Sub 'remove,not required


If Target.Count > 1 Then Exit Sub 'remove,not required

   If Not Application.Intersect(Target, Me.Range("h1:h174")) Is Nothing Then

        Cancel = True

       If Target = "" Then UserForm2.Show

    End If
End Sub