ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically multiplying totals on a userform (https://www.excelbanter.com/excel-programming/329532-automatically-multiplying-totals-userform.html)

Greg B[_5_]

Automatically multiplying totals on a userform
 
Hi all
I need to be able to have a userform automatically multiply the totals of
textbox 2 by textbox 7 and display it in textbox 10.

How do I do this?

Thanks

Greg



K Dales[_2_]

Automatically multiplying totals on a userform
 
In the UserForm's code module, put the following:

Private Sub TextBox2_Change()

TextBox10 = Val(TextBox2) * Val(TextBox7)

End Sub

Private Sub TextBox7_Change()

TextBox10 = Val(TextBox2) * Val(TextBox7)

End Sub

"Greg B" wrote:

Hi all
I need to be able to have a userform automatically multiply the totals of
textbox 2 by textbox 7 and display it in textbox 10.

How do I do this?

Thanks

Greg





All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com