Menu

incorrect addition

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

[email protected] sandip.dhamapurkar@gmail.com is offline

sandip.dhamapurkar@gmail.com is offline

external usenet poster

Posts: 29

Default

incorrect addition

Thanks

wrote:
Your TEXT boxes contain text, so VBA will add the two text strings
together as you have requested - two options for you

(1) store the results of the textboxes on the worksheet and have a
formula to sum them
(2) amend your code to be
total.value=val(contents.value)+val(Bldg.Value)

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Addition?	Frodo	Excel Discussion (Misc queries)	3	July 22nd 06 01:15 PM
Sum vs. Addition	davegb	Excel Programming	4	May 19th 06 09:03 PM
addition	dali	New Users to Excel	1	March 4th 06 06:40 PM
row addition	Threshold	Excel Worksheet Functions	3	March 17th 05 08:08 PM
Addition to code	gav meredith	Excel Programming	0	April 29th 04 02:05 AM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement