| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Calculated amount in a textbox on userform
Hi All, I have two dropdowns on userform, where users can select values
between 1-100, I want to display the difference between the two values selected in a seperate textbox. How can I do this? Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Calculated amount in a textbox on userform
Right click one of the dropdowns & "View code" - create a change event with
the following code: me.txt_YourTextbox.value = me.cmb_Drop1.value - me.cmb_Drop2.value and then repeat for the other drop down. Sam "sam" wrote: Hi All, I have two dropdowns on userform, where users can select values between 1-100, I want to display the difference between the two values selected in a seperate textbox. How can I do this? Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Calculated amount in a textbox on userform
Thank you sam, It was this simple and I was trying to complicate it with a
For look :) "Sam Wilson" wrote: Right click one of the dropdowns & "View code" - create a change event with the following code: me.txt_YourTextbox.value = me.cmb_Drop1.value - me.cmb_Drop2.value and then repeat for the other drop down. Sam "sam" wrote: Hi All, I have two dropdowns on userform, where users can select values between 1-100, I want to display the difference between the two values selected in a seperate textbox. How can I do this? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display $ in a userform textbox | Excel Programming | |||
| The amount calculated based on two entry criteria (somproduct?) | Excel Discussion (Misc queries) | |||
| How to feed a userform a variable to display in a textbox? | Excel Programming | |||
| How do I get a calculated amount to round to the nearest nickel? | Excel Worksheet Functions | |||
| Qn: Display Text in TextBox in Userform | Excel Programming | |||
Linear Mode
