SheetChange Event Error: HELP NEEDED

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Dave

Thanks to your suggestion I've been able to get a little further

Now I can see that the difference is not between a normal xls workbook or an add-in (xla)
I made another try and I discovered that when the cell that the event is monitoring (in my example $C$4) is a normal cell everything works fine, but if the cell is handled by a list of possible value (made trough the Data > Validation menu) then i keep getting the same error

Thank you for any further comment you may provide
Massimiliano Garr

P.S. I changed the "Target" to "Source" as it does means more to me (it is the source of the event
 
See another reply at the other thread.
Hi Dave,

Thanks to your suggestion I've been able to get a little further.

Now I can see that the difference is not between a normal xls workbook or an add-in (xla).
I made another try and I discovered that when the cell that the event is monitoring (in my example $C$4) is a normal cell everything works fine, but if the cell is handled by a list of possible value (made trough the Data > Validation menu) then i keep getting the same error.

Thank you for any further comment you may provide.
Massimiliano Garri

P.S. I changed the "Target" to "Source" as it does means more to me (it is the source of the event)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SheetChange event in add-in doesn't work: HELP 10
SheetChange fire UDF unintentionally 2
SheetChange event restore old value 1
SheetChange Event 2
Cell content change Event 7
sheet event wait for another event? 6
SheetChange event crashes using Range.set_value (C#) 12
Inserting Rows during a SheetChange event 4

Back
Top