Originally Posted by
greatheavy
Hello All,
I created a function refering to different spreadsheets (so far nothing exceptional).
On one of the sheets, I created a dropdown menu (control), linked to a cell.
When I do change the dropdown, then the function referring to it adjusts only one time after editing VBA (VBA editor).
After that, any change on the dropdown won't affect the function (though the cell to which it refers is updated)...
What I mean by VBA editing, is just adding a comment anywhere (not specifically related to the function)
Any idea??? I tried a sub on_change () calculate =>Same result...
Thanks all for your help...