No error message but Code not working

**mukeshbaviskar** · 07-19-2013, 12:50 PM

Hello friends,
I have inserted a code in "Access" sheet module to change row, insert dash and delete dash but the change row code is not working. I'm getting the correct result of first two codes namely 'insert dash' and 'delete dash' but not getting the result of third code namely 'change row'. There is no error in code but it's not working. I want to change the row when I enter any data in column 'y' and press enter or tab or right arrow . It's working fine in a separate sheet but not in this sheet.

Please correct my mistake in inserting the code.

Thanking you in anticipation.

Mukesh

**HaHoBe** · 07-19-2013, 01:03 PM

Hi, Mukesh ,

if you want your own event to get fired you should apply Class Programming to make it work - if you change to another sheet module and check what events are available you´ll find there is no Private Sub Worksheet_Changerow(ByVal Target As Range). So Excel doesn´t recognize that event.

Ciao,
Holger

**mukeshbaviskar** · 07-19-2013, 01:12 PM

Hello HaHoBe,
Thank you for your response. My problem is solved now. I simply merge two codes second and third by deleting end sub of second code and first line of third code.

It's working fine now.

Thank you.

Mukesh