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
Bookmarks