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

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

Bernie Deitrick wrote:
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

Thanks Bernie, the userform is exactly what I wanted to do, it works great.

Brian