View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Macro to run when cell click

I'm trying to write a macro to call a userform when you click in a cell. This
is what i've got which works when someone types a character in the cell.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$5" Then
userform1.show
End If
End Sub

Any way to change this so the form is called when the cell is selected?