Return a value programming

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lp12 - 25 Nov 2007 15:44 GMT

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.

Reply to this Message

Bob Phillips - 25 Nov 2007 15:59 GMT

Perhaps it should be

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

Signature

---
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)

> Hi,
> I have a form that I want to control the return value coming from a code
[quoted text clipped - 3 lines]
> Any thoughts?
> Thanks a lot in advance.

Reply to this Message

JLGWhiz - 25 Nov 2007 16:21 GMT

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.

> 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.

Reply to this Message

Lp12 - 26 Nov 2007 06:16 GMT

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:
[quoted text clipped - 7 lines]
> > Any thoughts?
> > Thanks a lot in advance.

Reply to this Message