Thanks a lot
On Fri, Jul 15, 2011 at 9:44 PM, STDEV(i) setiyowati.d...@gmail.com wrote:
*1.
**Worksheet.Change Event*
*
*Occurs when cells on the worksheet are changed by the user or by an
external link.
This event doesn't occur when cells change during a recalculation. Use the
Calculate
Hi Sir,
Can you please tell me what is difference between these two codes, Please
guide me.
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
--
the activecell or current selection.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de neil johnson
Envoyé : vendredi 15 juillet 2011 13:45
À : excel-macros
Objet : $$Excel-Macros$$ Hi I need your help , Please explain it with
example
juillet 2011 18:07
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Hi I need your help , Please explain it with
example.
Hi,
Private Sub Worksheet_Change(ByVal Target As Range)
is fired when you enter a value into a cell
Private Sub Worksheet_SelectionChange(ByVal Target
*1.
**Worksheet.Change Event*
*
*Occurs when cells on the worksheet are changed by the user or by an
external link.
This event doesn't occur when cells change during a recalculation. Use the
Calculate event to trap a sheet recalculation.
This example changes the color of changed cells to blue.
