trigger event not functioning

Is the sheet protected?

Was a cell in column 11+ changed manually?

If the code in that sheet? Right click sheet tab, View Code.

Did an error occur?

Are macros enabled?

Try closing Excel and reopen.

Originally Posted by Kenneth Hobson

Is the sheet protected?

Was a cell in column 11+ changed manually?

If the code in that sheet? Right click sheet tab, View Code.

Did an error occur?

Are macros enabled?

Try closing Excel and reopen.

No sheet not protected.
Yes unchanged cell manually
Yes macro enabled
Workbook has 10+ macro
I saved and reopened 3 times..
The event is running in other sheets..
But not this sheet..
Am I missing something?

Likely you had an error. Errors need to be handled. The way the code is written, I doubt that you want multiple iterations.

You can run Application.EnableEvents = True, close and reopen. For a one-off run of one line, I put it in Immediate window and enterkey at end.

Then use the 2nd sub here. The 1st was my test. I found 78 runs for one change.

Please Login or Register  to view this content.

Hi,
I have attached file..
In that due to the trigger event,the macro filter is not functioning...

You did not disable events prior to this:

Please Login or Register  to view this content.

So, for every cell in the used range of K:P, your sheet event fired many times. I doubt that you wanted that.

Kenneth Sir,
I am not able to get it exactly.. Can you tell me where should i modify, so that i want the macro to run..
My purpose is to filter the range and copy through macro..
Then by the event when the user inputs yes/no in the last visible row.. i want to copy it to another column
How to change that both works fine..

When the macro runs and stops at debug in thisworkbook.sheet3 line..
Y is to so?

You have several issues going on. Which do you want to solve first?

You lost me. For example, in Sheet3, I don't know what you are doing there. Please explain in words.

You would save yourself a lot of effort if you would use Option Explicit at top of each object: worksheet, module, etc. Then in VBE's Debug menu, Compile before any Run.

I made a few changes in Sheet3's BeforeDoubleclick code as commented and a bit more. Still, it really doesn't do anything in that sheet.

Please Login or Register  to view this content.

Hi,
my requirement is filter the school and copy the names corresponding axa/cxa/bxa and then asking the user whether user has completed updation so give yes/no for the same in a separate column .. then the yes are copied and no are deleted..


For this , since i have not used input box or have limited knowledge in macro, hence i tried a msg box..
first i filtered and copied the visible rows for the criteria to another column ..
there in the next column, asked the user to input yes/no
when last row is entered, either by change or doubleclick automatic copying of yes entries done..

for this the trigger event was provided by forum user for another query, i modified to my requirement.. so i dont understand where i am going wrong..
or am i totally wrong..

i want to know, why this event triggers, when the original macro does not use the target column right?