View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
casey casey is offline
external usenet poster
 
Posts: 80
Default Unload a Form using SelectionChange

I have a Calendar Form that is opened with a SelectionChange. Is there a way
to Unload it with a SelectionChange event? I assume it would have to be in
the same subroutine. Here is the current code.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("H:H,K:K,L:L")) Is Nothing Then
OpenCalendar
End If

End Sub

--
Casey