View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alathosco alathosco is offline
external usenet poster
 
Posts: 2
Default Activating a Procedure in an Excel Worksheet

Hello...
I've created a procedure called Force_UCase in the VBE using the often
copied example code shown below.
How do I get it to now perform in my spreadsheet?

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("B19:B60")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub