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