Return a value programming

[Lp12]

Hi,
I have a form that I want to control the return value coming from a code and
when I use: UserForm1.cargo.Value = AnswerCell.Offset(0, 2).Value , Im
getting an error 91 Object Variable or With block var not set.
Any thoughts?
Thanks a lot in advance.

 

[Bob Phillips]

Perhaps it should be

UserForm1.cargo.Value = Activecell.Offset(0, 2).Value

--
---
HTH

Bob

__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JLGWhiz]

It is telling you that you have not set AnswerCell as an object variable so
it does not know how to treat it. You will needd to do:

Set AnswerCell = Worksheets(?).Range(?) 'where you supply the ? info.

 

[Lp12]

Tnx all.....
My bad

It is telling you that you have not set AnswerCell as an object variable so
it does not know how to treat it. You will needd to do:

Set AnswerCell = Worksheets(?).Range(?) 'where you supply the ? info.