Hi, trying to keep my formulas hidden and have the same cell into which a value is placed act as the output (so you type it in, the formula acts on it, and it shows the new value in the SAME CELL). Is there a way to do this?
Thanks!
Hi, trying to keep my formulas hidden and have the same cell into which a value is placed act as the output (so you type it in, the formula acts on it, and it shows the new value in the SAME CELL). Is there a way to do this?
Thanks!
Only with VBA but I think that would be kind of confusing.
I think you'd need to be more specific about your requirement ... you'd need to have the formule *somewhere*
Regards
Say the formula is on another worksheet or hidden, and then use the VBA to "overwrite" the value that was originally input.
Eg:
1) "5" is entered in A1
2) the formula or vba runs (eg =A1+1)
3) A1 becomes "6".
OK, I'm really not sure why you would want to do this ... practical joke, maybe?
This approach uses a second worksheet with the formula ... in this case, in cell A1. The worksheet is set to xlVeryHidden so it isn't obvious. If you password protect the VBA project it's going to be hard to get at, though not impossible.
The visible sheet uses a Worksheet Change event to copy the value from the hidden sheet (Sheet2) to the cell in Sheet1.
Note that, if there are no other formula specified, the process will simply blank out any input into cells other than A1. Cell A21 just copies back what you key in.
As an intellectual exercise it was fun (?) ... but why?
Enjoy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks