Thread: Excel VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sheela sheela is offline
external usenet poster
 
Posts: 43
Default 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