Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to edit data in other cells from a formula
Hi everyone,
I've run into a problem with the fact that an UDF can't edit anything apart from the cell it was called from. I'm developing a wages spreadsheet, something like this: NAME | RATE |STD HRS |ACTUAL HRS|PAY | where PAY = CalculatePay() I have a function called CalculatePay, and if the actual hours are less than they should be it asks for a reason and updates another sheet in the workbook. This is where I run into problems, as I can't modify the cells. Can anyone suggest another approach? TIA S. Armondi -- To contact me by email, remove _NOSPAM_ from the address. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to edit data in other cells from a formula
Hi
not possible with UDFs. The only thing that could do this would be event procedures (if you require and automatic update) -- Regards Frank Kabel Frankfurt, Germany Samuele Armondi wrote: Hi everyone, I've run into a problem with the fact that an UDF can't edit anything apart from the cell it was called from. I'm developing a wages spreadsheet, something like this: NAME | RATE |STD HRS |ACTUAL HRS|PAY | where PAY = CalculatePay() I have a function called CalculatePay, and if the actual hours are less than they should be it asks for a reason and updates another sheet in the workbook. This is where I run into problems, as I can't modify the cells. Can anyone suggest another approach? TIA S. Armondi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need VB formula to edit and save data | Excel Worksheet Functions | |||
Edit many cells at once to add a charater to existing data? | Excel Discussion (Misc queries) | |||
edit data in multiple cells | Excel Worksheet Functions | |||
When I edit the cells referenced in my formula, the result does ch | Excel Worksheet Functions | |||
How to use macro to edit data in Excel cells | Excel Discussion (Misc queries) |