New Problem !!

[alta77]

I have created a Global variable that links sheet1 with sheet2 in the Change event of sheet1. When I change my information in sheet1 it automatically updates sheet2. Even when I use a dropdown box the information appear in shee2. I have write a formula in sheet1 that display a value in a nother cell when you use the dropdown box. The problem I have is that the info is not displayed in sheet2. What do I do to make this formale display because it is not seen as change. Even when I use a link it does the same. What can I do to display the data

Thank you

 

[SkipVought]

When a formula calculates and displays a new value, that does not trigger the CHANGE event.

Check out the Calculate event.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}