Another newbie question please
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
|