Show userform by selecting a cell

[Stevie p]

Hi,
is it possible to show userform1 by selecting cell B2

 

[mvptomlinson]

Hi Stevie, you could use the Worksheet_SelectionChange event, e.g.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
    UserForm1.Show
End If
End Sub

 

[Stevie p]

That works great, thank you very much.