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

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


wrote in message
ups.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.valu e

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