Brian,

When you say form, if you mean a userform, then something along the lines of:

UserForm1.TextBox2.Text = Evaluate(UserForm1.TextBox1.Text)

If you mean a spreadsheet that you've set up as an input form, then it depends, and you'll need to
describe your situation better.

HTH,
Bernie
MS Excel MVP


"Ashnook" <brian@atashnookcdtfreeservedotcodotuk wrote in message
. com...
In a form I have a text box containing "=materials!b3".

I now want another text box to contain the content of the referenced cell, so if cell
'materials!b3' contains 32 I want this other text box to contain 32.

Simple for you experience guys but I cannot make it work!

Thanks in anticipation

Brian