Updating cell exit sub

[silmara]

Why does the update of a cell causes my public subroutine to exit ? This is the line in the subroutine:

[ae26] = Cells(ExposureTimeRow, (Selection.Column + 1)).Value

It does exit only if the subroutine is called from another cell, i.e. the formula at a1 is "=mysubname()". If the subroutine is called from a button click, then it is no problem.

Your help is appreciated,

Silmara

 

[macleanb]

Anything that is called from a cell cannot touch the sheet at all (well there are a few exceptions) - you cannot "do" anything to the worksheet this way. The normal alternative is to use the worksheet_change event on the worksheet code tab.

 

[silmara]

macleanb

Ok. Good idea the worksheet_change event ...

Merci beaucoups !

Silmara