How do i enable a function to change other cells?
 

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

How do i enable a function to change other cells?
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Bommel wrote:
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