Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a simple input form, there are 3 boxes which hold numbers. A net cost is firstlykeyed into a text box called 'tbNet' then if the item is vatable a 'VAT @ 17.5%' checkbox is selected and this calculates 17.5% of the input disabled text box called 'tbVAT'. The 3rd text box 'tbGross' needs to add the other two text boxes togethor, I keyed this bit of code as Private Sub's 'tbGross_Change' and 'tbVAT_Change' the code I have used is 'frmCashRecd.tbGross.Value = frmCashRecdtbVAT.Value + frmCashRecd.tbNet.Value' but rather than sum the two values togethor (i.e. 100 + 17.50 = 120) the value in 'tbGross' is 10017.5 (i.e. it concatenates the two togethor). Is there a bit of code I can use that will sum instead? Please help! Cheers Brian, Manchester |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link Text Boxes on Form? | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Form, or seperate text boxes? | Excel Programming | |||
Summing the values in text boxes | Excel Programming | |||
How to iterate through all Text Boxes on a Form? | Excel Programming |