How do i enable a function to change other cells?

[Guest]

i want to write a function that automatically fills other cells so i can
have a dynamic design.
here is my testfunction, if you tell me what to do to make it work, i can do
the rest alone:

public function test(text as string) as string
Cells(1, 2).value = "it works"
test = text
end function

thanks for your help
bommel

 

[Frank Kabel]

Hi
if you want to call this function in a spreadsheet cell the simple
answer is: this is not possible.