I have some controls in an userfor, their contents (value/text) are the
result of a look up in a sheet. I want to update/change those values and
paste them back in the sheet in the same cells they come from. When I try to
do it I get the "Object Requiered" error.

Here is an example
ws.Range(X).Offset(0, 6).Text = FrmMove_In.CheckBox1.Caption

ws= is the sheet where I'm retrieving the record from
x=is the column where the record is.


Help is greatly appreciated.