is it possible to write formula like this ?

Hi

Put your text in A1 and then =A1 in the cell you want to display your text

Not sure exactly what you are looking to do but you can use T() as one way. In A10 place T(A1) and whatever you type in A1 will appear in A10.

In cell A1 type your text Example:
HELLO

In Cell A3 type the fomula:

=(A1)

A3 is going to show: HELLO

Marcelo.

insert a module into your book

type the following

Function test(testvalue)
If testvalue = "hello" Then
test = "hello welcome to oz"
Else
test = ""
End If

End Function

On the spread sheet you need only type
this in A10
=test(A1)

now type hello and it will say welcome to oz in cell a10
otherwise a10 will be blank

this can be done with an if statement as well. The function is capable of many more things so I thought I would put it out there.

You could also use something like this.

Function Test(TestValue)

Select Case UCase(TestValue)
Case Is = "HELLO"
Test = "WELCOME TO OZ"
Case Is = "BYTE ME"
Test = "shut up you putz"
Case Is = "GOOD BYE"
Test = "SEE YA WOULDN'T WANA BE YA"
Case Else
Test = "not a valid input"
End Select

End Function

I see you do not want code but I am not sure what you want.

type in sheet 1 a1 and have the result appear in sheet2 a2 using linking

Simply type = in a2 of sheet then change sheets click on the source cell.

Now type in sheet 1 a1 and sheet 2 a2 will read what is typed.

this works just as well with just same sheet
a1 to a2 linking.

in cell a2 type =a1

Other than that I think you will need to define your premise more.

You tell us we do not understand what you want, and yet you are unwilling to take the extra steps to explain exactly what it is you are trying to do. You have been given plenty of options to do what you are asking, and from the replies we all looked at your problem from the same angle, so with that we understand what you have given us. As Epidemic stated maybe you need to give a clearer definition.

how about : in A1 :

=indirect(A10)

Quote

Originally posted by Anonymous
how about : in A1 :

=indirect(A10)

that was me...

From what I understand your question to be, the answer is no. You cannot change the contents of a cell by entering a formula in another different cell.

Regards
Weasel

The only option i can work out from your OP is to utilise an IF statement

So that A = B changes C or A

If thats the case can i ask for a more detiled exampl of you exact requirements, and ill work on a deeply nested fuchtion non VBA if i can to assist you.

Kindest rdgs

Jack in the UK