| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiplying specific data within a range to get column totals | Excel Worksheet Functions | |||
| How do I automatically compile totals from 12 worksheets into 1? | Excel Worksheet Functions | |||
| Printing running totals automatically | Excel Discussion (Misc queries) | |||
| How do I automatically drop totals from one worksheet into another | Excel Worksheet Functions | |||
| Are sub-totals able to be set to be bold automatically? | Excel Discussion (Misc queries) | |||
![Greg B[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
