Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox calculation
Hello, I have 3 textboxes (Labour, Materials and Total) I am trying to get the totalcharge textbox to show sum of labour + materials after labour change and/or materials change but it this is what happens: Labour = £10.00 Materials = £5.00 Total = £10.005 (Instead of just £15.00) and if i tab back up to the labour box the totalcharge value changes again to £10.00£5.00 my code is: Private Sub Labour_AfterUpdate() TotalCharge.Text = Labour.Value + Materials.Value Labour.Text = Format(Labour.Value, "£###,,###.00") End Sub Private Sub materials_AfterUpdate() TotalCharge.Text = Labour.Value + Materials.Value Materials.Text = Format(Materials.Value, "£###,,###.00") End Sub I'm not really sure when to use .text or .value either any help would be really appreciated!! thanks -- johncassell ------------------------------------------------------------------------ johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016 View this thread: http://www.excelforum.com/showthread...hreadid=385423 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox calculation | Excel Programming | |||
Date Calculation in UserForm TextBox | Excel Programming | |||
Userforms - Display result of a calculation in a textbox | Excel Programming |