Autcalculate userdefined functions in Excel

[remvs]

Hi all,

i have a few optionbuttons on an Excelsheet.
When clicked the whole sheet including my selfcreated functions need to be recalculated.

the sheet itself is no problem. but the cells with my homemade function simply dont update.

only when i select the cell (with the function) and hit enter it recalculates.

Anyone an idea how to recalculate a cell with my function?

thanx in advance
Remvs from holland

[BrianB]

Put

Application.Volatile = True

as the first line of each function.

[remvs]

Dear Brian,

im not behind my own pc now, and will not be for the coming 2 days.

I'll check your suggestion asap

thanx alot
remvs

[remvs]

it works just fine! thanx!
took a little more then 2 days to get back at you ;-)