Im looking to display a user form when any cell between row 10 and 65 in column 13 are selected.
Following is currently used
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 13 And Target.Row > 9 And Target.Row < 66 Then Exit Sub
userformf50.Show
End Sub
It works for what I want but if i select any cells above row 10 or below row 65 in any column it also displays the user form.
It is also possible that when i move off the selected cell that the user form would automatically hide itself again.
Thanks for any help
Ladjets
Following is currently used
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column <> 13 And Target.Row > 9 And Target.Row < 66 Then Exit Sub
userformf50.Show
End Sub
It works for what I want but if i select any cells above row 10 or below row 65 in any column it also displays the user form.
It is also possible that when i move off the selected cell that the user form would automatically hide itself again.
Thanks for any help
Ladjets