Turning off excel's autodelete

[aad401]

Hello, and thank you in advance for your help.
Excel has a built in feature that deletes the previous character string in a cell if new data is entered.
I am creating a user checklist form that adds in new data to a cell when a box is checkmarked, without deleting what was there in the first place. Therefore, I need to turn off this built in feature for just one cell.

A sample of current code is:

Private Sub a2_Click()
Range("C2").Select
ActiveCell = "a2"
End Sub

Private Sub b4_Click()
Range("C2").Select
ActiveCell = "b4"
End Sub

In this example, when the boxes "a2" and "b4" are checked, Cell "C2" should read "a2b4"

Thank you very much for your time and help.

[mikerickson]

You could use code like

Please Login or Register  to view this content.

BTW, when naming checkboxes, and other controls, its a good idea to give them a name that can't be confused with a cell address.

[aad401]

THANK YOU VERY MUCH. I don't think you know how much time and effort you have saved me.