![]() |
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 |
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