LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userfrom problem... the dude Excel Discussion (Misc queries) 3 May 31st 06 09:33 PM
How do you use DTpicker in a Userfrom TDR Excel Discussion (Misc queries) 2 August 9th 05 01:43 PM
can you use the dtpicker in an userfrom TerryR Excel Worksheet Functions 1 August 1st 05 03:20 PM
Userfrom textboxes Jo[_6_] Excel Programming 2 October 21st 03 06:56 PM
Userfrom textboxes Jo[_6_] Excel Programming 1 October 21st 03 05:47 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"