Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA
Hello,
I have a problem. When I try total up values fom a list of textboxes using the formula as below, it actually combine the values from all the textboxes. __________________________________________________ _______ txtFinalBill.Text = Val(txtCalculatedDemandCharge.Text) + Val(txtEmp.Text) + Val(txtEmop.Text) + Val (txtFirmStandbyCharge.Text) + Val (txtNonFirmStandbyCharge.Text) + Val (txtPowerFactorPenalty.Text) + Val(TextBox25.Text) __________________________________________________ ________ Has it got its limitation in totalling up the values? Thanks, Sheela |