1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell Clears When Not Desired

Discussion in 'VBA Macros' started by JPhotonics, May 18, 2017.

  1. JPhotonics

    JPhotonics Member

    Messages:
    36
    I have a VBA and Macro enabled worksheet which is working perfectly thanks to the help of the guys on here... except I have a cell for people to add comments and if they try to open the cell back up to edit/add information, it clears out all past information.

    I want the information to be stored in this cell unless someone selects the cell and actually DELETES it.

    Please help!

    Thanks,
    Jake

    Attached Files:

  2. JPhotonics

    JPhotonics Member

    Messages:
    36
    Doing some messing around with the form, F2 and double-click both clear the contents of any of my cells which accept text.

    I want the F2 or double-click to allow the user to edit and KEEP the already-entered text within the cell. I only want the actual DELETE key to delete the contents of the cell.
  3. narunfca

    narunfca Member

    Messages:
    67
    You have defined cell D10 as hidden cell. Unprotect the Sheet. Go to cell properties of D10 by clicking that cell and pressing Ctrl+1 and remove the hidden option in the cell. This will solve the problem.
    NARAYANK991 likes this.
  4. JPhotonics

    JPhotonics Member

    Messages:
    36
    Such a simple problem and simple fix. I didn't even think to check that. Thank you very much!

    Can I ask what gave it away and told you the cell was Hidden which was causing this issue?
  5. narunfca

    narunfca Member

    Messages:
    67
    Simple. After pressing F2, if I cancel the operation and the original content reappears, it means sheet is protected and cell property is hidden.
  6. JPhotonics

    JPhotonics Member

    Messages:
    36
    Ah, okay. Thank you again for the help.

Share This Page