LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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.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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling Info Schwimms Excel Discussion (Misc queries) 0 June 6th 07 09:00 PM
Pulling info from a list Patrick Excel Worksheet Functions 2 May 2nd 07 09:44 AM
COPY LABEL FORM FROM EXCEL TO A LABEL xrayAndi New Users to Excel 1 March 5th 06 02:21 PM
Pulling a Letter from a cell and filling another cell with info nick s Excel Worksheet Functions 16 November 28th 05 04:10 AM
Pulling info into another sheet Teric506 Excel Worksheet Functions 0 September 26th 05 05:08 PM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"