| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Linear Mode
