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: 39
Default generating text box value based on equation from other boxes

I've got an invoicing macro that totals 4 amount boxes and a amount
paid box (input boxes on the form). I'm trying to get the total box to
update based on the amounts in this box, but i keep getting a type
mismatch, here's what i have for the change events on the five inpute
boxes

Private Sub FirstAmtBox_Exit(ByVal Cancel As MSForms.ReturnBoolean)
BalanceDueAmountBox.Value = ((FirstAmtBox.Value * 1) +
(SecondAmtBox.Value * 1) + _
(ThirdAmtBox.Value * 1) + (FourthAmtBox.Value * 1) -
(AmtPaidBox.Value * 1))
End Sub

any suggestions?

 
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
User Form Text Boxes - Copy format of text boxes NDBC Excel Discussion (Misc queries) 3 July 2nd 09 02:02 AM
Changing color in text boxes based on content oldybutgoody Excel Discussion (Misc queries) 1 October 23rd 07 04:42 PM
Generating time based series Pete Charts and Charting in Excel 1 September 19th 06 08:28 AM
Generating a Userform based on a worksheet Glenn Excel Discussion (Misc queries) 0 March 4th 05 07:25 PM
Having data populate text boxes based on Combobox Value Todd Huttenstine[_2_] Excel Programming 1 November 10th 03 01:35 AM


All times are GMT +1. The time now is 10:43 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"