Hi
I wanted to have a worksheet change event whenever I change a cell in
certain column (say column B) to something else the event would happen
I figure this
Private Sub Worksheet_Change(ByVal Target As Range)
????
If ????? and Target.Column = 2 then
Application.EnableEvents = False
Code, code
End if
Application.EnableEvents = True
End Sub
Thanks.
B
--
Message posted from
http://www.ExcelForum.com