+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Same output cell as input

  1. #1
    Registered User
    Join Date
    07-12-2010
    Location
    Edmonton, Canada
    MS-Off Ver
    Office 2007 (Access, Excel)
    Posts
    2

    Same output cell as input

    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!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,350

    Re: Same output cell as input

    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

  3. #3
    Registered User
    Join Date
    07-12-2010
    Location
    Edmonton, Canada
    MS-Off Ver
    Office 2007 (Access, Excel)
    Posts
    2

    Re: Same output cell as input

    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".

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,350

    Re: Same output cell as input

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1