error on value linking with drop down

[leighmills33]

Hi,

Can anyone point out why I am getting an error with this code:

Please Login or Register  to view this content.

F30,H30 and J30 are drop down menus.

Thanks

[leighmills33]

I have adjusted the code like so:

Please Login or Register  to view this content.

The only problem I am having now is Excel is freezes when I change a value.

Thanks

[leighmills33]

I got there in the end, I just changed it to selection change.

Thanks for those that were trying to help

[Domski]

Try this:

Please Login or Register  to view this content.

Dom

[teylyn]

Hello,

at the beginning of the code, put

Please Login or Register  to view this content.

Since you are changing cell values with the code, the code is constantly calling itself, with each cell change, and it ends up in an endless loop. Disabling events will avoid that.

cheers, teylyn