Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Output without =
I need to be able to output the results of a formula from one sheet t another and include the output in a form (using a locked text box wit the controlsource as the cell with the formula), without using a equals in lets say cell a1 on sheet 1 which would then be =sheet2!a1 because i will be deleting the row. I need to be able to delete the row that holds the output to my formul therefor it cannot be =sheet2!a1 because it would be erased. I know ho to delete the row and that i need to delete it (do not argue on thi point in ur reply). How can i output the result of a formula (like a combobox cell link o control source would)? I will appreciate any sugestions because i need to get this sorte quickly. Thank -- GAZZAT ----------------------------------------------------------------------- GAZZAT5's Profile: http://www.excelforum.com/member.php...fo&userid=1680 View this thread: http://www.excelforum.com/showthread.php?threadid=32006 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Output without =
here's an example of what i mean. Check out the code on the buttons an the formulas. It shows essentially what happens at the moment, but it can't delet the row (and if it did the formula would disappear +------------------------------------------------------------------- |Filename: example.zip |Download: http://www.excelforum.com/attachment.php?postid=2803 +------------------------------------------------------------------- -- GAZZAT ----------------------------------------------------------------------- GAZZAT5's Profile: http://www.excelforum.com/member.php...fo&userid=1680 View this thread: http://www.excelforum.com/showthread.php?threadid=32006 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a List Output from a Horizontal Array Input | Excel Worksheet Functions | |||
conditional formatting w/ color as input vs output | Excel Worksheet Functions | |||
Multiple input and output results | Excel Discussion (Misc queries) | |||
Creating a chart (Getting the correct input and output) | Excel Programming | |||
Diff. btw Open [path] For OUTPUT vs. For INPUT | Excel Programming |