UDF, Dropdown select and Worksheet_Change VBA Problem

[lulupatel]

Dear Sir

I have Data Validation in B3. and also I have User define Function. for Column Number to Column alphabet.

Please Login or Register  to view this content.

and for UDF

Please Login or Register  to view this content.

my Problem is If I use this UDF in any range. Dorp Down Select change dose not trigger VBA. its can trigger by only Typing.

is there any solution. here I attached sample file.

[Norie]

If I use the UDF the dropdown still triggers the change event.

Where exactly are you using it?

[lulupatel]

Dear

here I attached my Original project fill.. just look in to "form" sheet G2 i am using drop down.

same as I used in test file.

but in my laptop in test file also not triggering. if I change by selecting from drop down. yes. it can trigger if I type manually from key board.

if you say it is working there. then I am confuse that is it problem with excel 2007 or its a problem with my laptop.

[Norie]

Where are you using the UDF?

[lulupatel]

actually I am using UDF in many sheet. in current sheet u can look in K3 range there is I use UDF. i think u need protract password. "kamath"

[lulupatel]

can you can in test file which I upload first. is it really triggering after change value by selecting drop down. ( not by typing ). and also in some cell use UDF. if its working there then I need to check with another laptop

[Norie]

I can't find the UDF being used in any workbook.

I can only find it in the code and I'm pretty sure you could change the code to use Cells so it's not needed.

For example this,

Please Login or Register  to view this content.

could probably be written something like this.

Please Login or Register  to view this content.

[lulupatel]

I have many UDF in my project. which I can not convert in Excel formula.

I am surprising. you did not find UDF in any workbook. in a test work book I clearly insert with cell comments. you can check if you use " = CtoL(3) " in any cell. then after drop down select is not triggering.

[Norie]

I searched both workbooks you uploaded and couldn't find the UDF CtoL on any worksheet.

I also tried adding some examples of the UDF in various cells on various worksheets.

Nothing stopped the dropdown triggering the change event.

[lulupatel]

may be some problem with my laptop. I need to check using with another laptop.