Worksheet Change event

pm · May 14th, 2002, 08:29 AM

For some reason when I add a row to a worksheet, the change event does not seem to fire..what may i be doing wrong?

dk · May 14th, 2002, 08:35 AM

Hi,

The Change event is only fired if the contents of a cell change. Inserting a row won't cause the contents of any cells to change (except maybe some calculated cells) so the event won't be fired.

You could use the Calculate event to trap this although it's not 100% foolproof.

Regards,
Dan

pm · May 14th, 2002, 08:38 AM

actually i just added one cell and tabbed to the next cell and it did not fire..
please help!

dk · May 14th, 2002, 09:10 AM

You need the Selection_Change event then e.g.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "You are now in cell " & Target.Address
End Sub

HTH,
Dan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 08:29 AM	#1
pm New Member Join Date: Apr 2002 Posts: 19	For some reason when I add a row to a worksheet, the change event does not seem to fire..what may i be doing wrong?

May 14th, 2002, 08:35 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, The Change event is only fired if the contents of a cell change. Inserting a row won't cause the contents of any cells to change (except maybe some calculated cells) so the event won't be fired. You could use the Calculate event to trap this although it's not 100% foolproof. Regards, Dan

May 14th, 2002, 08:38 AM	#3
pm New Member Join Date: Apr 2002 Posts: 19	actually i just added one cell and tabbed to the next cell and it did not fire.. please help!

May 14th, 2002, 09:10 AM	#4
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	You need the Selection_Change event then e.g. Private Sub Worksheet_SelectionChange(ByVal Target As Range) MsgBox "You are now in cell " & Target.Address End Sub HTH, Dan