Trigger worksheet event_UDF

Hi

i am using User Define Function in workbook to convert amount into words. but when i use the UDF worksheet events are not triggering. In a worksheet there is drop down (Yes/No) on which events are triggered.

strange but when i select the drop down cell & Press F2 and than press Enter only that time event got triggered.

i will appreciate any help on this...!


UDF conflict with Worksheet Change Event Handler
triggering a non volatile UDF()

HI,

I think it would be best if you attached a copy of the workbook.
This would give us a better ideal of your request.