Automatically Place Text, which is user-editable

[Raustin]

Hello,
This might be a simple, straight forward issue.
I am trying to automatically place text from one cell into another cell, and have that cell, editable.
Let me Explain. If i have "Hello" in Cell A1, I would like to have a formula in say, cell A2, that automatically places the text "Hello" (of A1), into A3.
The reason for this is that A3 contains no formula, just default text "Hello" which can be modified by the user, without disturbing the original formula in A2.
Can this be done in Excel?

Thanks for any and all help,
Randy

 

[JPM]

You can't do this with a formula, as a formula only displays things in its own location, e.g. if you want to display "Hello" in A3 then the formula has to be in A3.

What you are trying to do would have to be done via VBA code. For example if you place this code on the Worksheet (not in a module):

Private Sub Worksheet_Activate()
Range("A3").Formula = Range("A1").Formula
End Sub

Then every time you activate this worksheet (e.g. switch from Sheet2 to Sheet1) it will trigger this code.

 

[Raustin]

OK, Thank you very much. I will give it a try, as this is a bit new for me, but seems simple enough
If there are any other suggestions, i will be happy to hear from everyone.
Thanks again,
Randy

 

[JPM]

Check it out there are a bunch of different options if you are willing to go the VBA route. For example you can set it so that every time you select a different cell, it will post whatever is in A1 into A3 by using this code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A3").Formula = Range("A1").Formula
End Sub

 

[Raustin]

Ok i tried that.. working great...
How would the code display if A3 should only change when A1 changes, otherwise it is left as-is.
Thanks again for the help,
Randy