Can a Function kick off a sub routine or write to other cells?

[MrTeeny]

Don't think it can kick off a subroutine but is it possible for the function to write to other offet cells, i.e. I put =someFunction(22) in A1 would that function be able to write data to A2 as well?

 

[Kenneth Hobson]

Call sub=Yes
Write to other cells=No

 

[Haluk]

Actually, by calling a sub from the function you can write to another cell.

The link below shows this with examples.

https://wellsr.com/vba/2016/excel/how-to-change-another-cell-with-a-vba-function-udf/

 

[MrTeeny]

Actually, by calling a sub from the function you can write to another cell.

The link below shows this with examples.

https://wellsr.com/vba/2016/excel/how-to-change-another-cell-with-a-vba-function-udf/

Thanks Haluk, looks the sort of thing I'm trying to acheive