View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default sum function in a userfrom

Have a command button that does it

e.g.

TextBox4.Text = Format(CDbl(Textbox1.Text) + _
CDbl(Textbox2.Text) + _
CDbl(Textbox3.Text),"#,##0.00")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"niteman" wrote in message
...
Hello everybody, I new at this and I'm trying to make a userfrom that well
sum several txtboxes with the total at the bottom of the form, the
information from the txtboxes, is use to update a worksheet, kind of like
forcastsales for one day's work from 11AM -11PM how can I do it before
updating the worksheet getting the total of the day.
eny help well be in advance apreciated