 # is it possible to write formula like this ?

• Range A1 ="display Text at Range("A10")="WELCOME TO ozgrid"

is it possible ?

That mean if I write formula in a one cell that result should appear in other cell.

I know in code possible. I want it in formula.

Thanks

• You did not understand what i am asking you.

• 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

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)

• 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

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!