Pulling Info From Cell To Form Label

Hi:

In a project I'm doing, I put two values from a form to a cell in a
worksheet:

current value of a spinButton, walue displays in label,.............

sheets("WorkingArea").range("g3") =
frmQueryResult.lblQueryResultdesiredUnitsNum1.value

.............and a price from a label

sheets("WorkingArea").range("h3") =
frmQueryResult.lblQueryResultPriceUnitNum1.value

Work great up to this point........

Cell i3 within this worksheet is a calculated cell:

= g3 * h3


I am trying to take this calculated cell value and pull it into a label
on a form:


frmQueryResult.lblQueryResultItemTotalNum1.caption = _
sheets("WorkingArea").range("i3").value

This is not working..................................

Ideas???

Thanks,
Brian

Your code should work. What exactly do you mean by "not working"?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


<smithb2@student.gvsu.edu> wrote in message
news:1145289397.892851.40420@e56g2000cwe.googlegroups.com...
> Hi:
>
> In a project I'm doing, I put two values from a form to a cell
> in a
> worksheet:
>
> current value of a spinButton, walue displays in
> label,.............
>
> sheets("WorkingArea").range("g3") =
> frmQueryResult.lblQueryResultdesiredUnitsNum1.value
>
> ............and a price from a label
>
> sheets("WorkingArea").range("h3") =
> frmQueryResult.lblQueryResultPriceUnitNum1.value
>
> Work great up to this point........
>
> Cell i3 within this worksheet is a calculated cell:
>
> = g3 * h3
>
>
> I am trying to take this calculated cell value and pull it into
> a label
> on a form:
>
>
> frmQueryResult.lblQueryResultItemTotalNum1.caption = _
> sheets("WorkingArea").range("i3").value
>
> This is not working..................................
>
> Ideas???
>
> Thanks,
> Brian
>

I agree the code should work..........the logic seems to be there, but
the value within range i3 is not being put into the label for some
reason.

I will post the soloution if I find one.

What do you think the problem could be?

Have a great day,
Brian