Activating a userform by selecting a cell

[Andy Gee]

Can I activate a userform by just selecting a cell?
Any help will be great!

 

[Audiojoe]

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If Target.Address = "$D$1" Then UserForm1.Show

End Sub

 

[Andy Gee]

Nice one! Works great!