Control Source on UserForm
Richard,
If you mean dynamically, you can use
Textbox1.ControlSource="Sheet3!A3"
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Richard" wrote in message
...
I am still confused about control source - in relation to
which sheet it affects. How do i make it so that i choose
which sheet is affected by the input of data into a text
box on Userform.
On one form i wish to fill out the value, which will then
be used in a lookup calculation, and then a further form i
wish to retieve a vlue fomr the spreadsheet to populate a
textbox which is for viweing only. These data are on
different sheets, hence my question above.
Thanks in advance
Richard
|