Mirror data of one cell to another

Hi i am looking to miror the data of one cell (cellA) to another Cell (cellB)
Cell A I need to add the data to and for it to automaticaly appeares in cell B
I can not have any formulars in cell B because it is controlled by a macro button and deleates the formulars
I hope i have explaind it properly thanks Ron

Please click on the forum rules link at the top of the page and take time to read and then amend your question title to something more meaningful

Please read the Forum Rules & edit your title appropriately

You'd need to use VBA to do this.
Right click on the sheet tab and "View code"
Paste in this code

Please Login or Register  to view this content.

If anything is inputted into A1 (Cells(1,1)), then that value is automatically mirrored in B1. Change the Cells values to fit your needs. Does this work for you?

So you are trying to add this to a workbook that already has a password that protects the VBA? Hmmmm