Change Value outside of Cell
 

Hello. I'd like to know if there is a way to change the value of a cell
without having a function in that cell. I don't know how to explain exactly
what I want to do but if any of you know of a way that I can write a function
that will enter values into a different cell I would be most grateful.
Thanks for your time.

Change Value outside of Cell
 

If you are asking can you write a function that is called from one cell and
updates the value in another cell, that can not be done. User defined
functions called from a spreadsheet can only modify the cell that they are in.

On the other hand if a sub or function is called from code then it has the
ability to update whatever it wants.
--
HTH...

Jim Thomlinson


"Abode" wrote:

Hello. I'd like to know if there is a way to change the value of a cell
without having a function in that cell. I don't know how to explain exactly
what I want to do but if any of you know of a way that I can write a function
that will enter values into a different cell I would be most grateful.
Thanks for your time.

Change Value outside of Cell
 

How might I be able to do that then. Hopefully it isn't too terrably
compicated.

"Jim Thomlinson" wrote:

If you are asking can you write a function that is called from one cell and
updates the value in another cell, that can not be done. User defined
functions called from a spreadsheet can only modify the cell that they are in.

On the other hand if a sub or function is called from code then it has the
ability to update whatever it wants.
--
HTH...

Jim Thomlinson


"Abode" wrote:

Hello. I'd like to know if there is a way to change the value of a cell
without having a function in that cell. I don't know how to explain exactly
what I want to do but if any of you know of a way that I can write a function
that will enter values into a different cell I would be most grateful.
Thanks for your time.

Change Value outside of Cell
 

You can just record a macro. Tools - macro - Record new macro... Add a vlue
to a cell and stop recording. Delete the value that you just entered when you
recorded the macro. Select tools - macro - macros and run the macro taht
you just recorded... That should get you a start...
--
HTH...

Jim Thomlinson


"Abode" wrote:

How might I be able to do that then. Hopefully it isn't too terrably
compicated.

"Jim Thomlinson" wrote:

If you are asking can you write a function that is called from one cell and
updates the value in another cell, that can not be done. User defined
functions called from a spreadsheet can only modify the cell that they are in.

On the other hand if a sub or function is called from code then it has the
ability to update whatever it wants.
--
HTH...

Jim Thomlinson


"Abode" wrote:

Hello. I'd like to know if there is a way to change the value of a cell
without having a function in that cell. I don't know how to explain exactly
what I want to do but if any of you know of a way that I can write a function
that will enter values into a different cell I would be most grateful.
Thanks for your time.