LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Adding values in textboxes?

As previously answered:

In the Exit Event of each textbox put in the code

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Textbox4.Text = Format(clng(textbox1) + clng(textbox2) +
clng(textbox3),"0")
End Sub

Repeat for Textbox2 and Textbox3

You can also use the afterupdate event.

Change clng to csng if the numbers will be decimals/fractions.

your cint of the concatenated result is the right thought, but wrong answer.
What you seem to not know is that when dealing with strings the plus sign
(+) also acts as a concatenation operator - and all values in a textbox are
strings, even if they look like numbers.

--
Regards,
Tom Ogilvy

"Gary Phillips" wrote in message
...
Okay, stupid question.

I have 4 textboxes... three of them are enabled so the user can enter an

integer value in each of them.

The 4th one is disabled, it will display the total of the 3 values the

user enters.

So on the txtOption01_Change(), txtOption02_Change(), and

txtOption03_Change() event I want it to add those values together and
display their total in the 4th textbox.

The way it happens now is like this...

txtOption01 = 5
txtOption02 = 5
txtOption03 = 5
txtOption04 = 555

I even tried converting it to Int but that doesn't work.

txtOption04.Value = CInt(myInt)

Is that right?



 
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
Adding values in textboxes? Bob Phillips[_7_] Excel Programming 0 July 27th 04 06:26 PM
Adding values in textboxes... Tom Ogilvy Excel Programming 0 July 27th 04 05:42 PM
Adding values in textboxes... Jake Marx[_3_] Excel Programming 0 July 27th 04 05:38 PM
Adding the values of 2 textboxes Ben Allen Excel Programming 3 April 29th 04 09:05 PM
Add values of textboxes together Candee[_10_] Excel Programming 4 December 5th 03 07:05 PM


All times are GMT +1. The time now is 06:18 AM.

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"