Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling Info | Excel Discussion (Misc queries) | |||
Pulling info from a list | Excel Worksheet Functions | |||
COPY LABEL FORM FROM EXCEL TO A LABEL | New Users to Excel | |||
Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
Pulling info into another sheet | Excel Worksheet Functions |