Heip ...

I created a multipage spreadsheet that uses a UDF to update cells depending upon the settings of another cell. This basically lets me select a value depending upon the user answering a question using a set of preselected answers defined by data validation criteria (example: yes / no). This lets me update all of the questions on all sheets instead of having an equivalent formula in each cell.

The issue, changing sheets results in the answers form the prior selected sheet being displayed on the current selected sheet. The UDF either does not auto calculate on page change or retain its output on a page when moving from page to page.

I am a novice at Visual Basic and am learning as I go.

Autorecalculation is enabled and the UDV is set to volatile.

What am I missing?


Thanks.