Userform textbox help
Hi, I have created a userform1 with the following:
textbox2 is used to enter an amount("$0000") this is linked to sheet1 cell ("F10"). I have a formula in cell ("M10") that devides the amount entered in ("f10") by 10. I have textbox6 in the userform that displays the result by linking this to range("M10"). I am trying to get the data in textbox6 to display the result automatically however I am not too sure how to do this, I currently have it set up so that the results are displayed in the userform when I click onto the form however I am not sure how to make texbox6 auto update? can somebody please give me a suggestion? thanks Paul |
Userform textbox help
Hi,
I've done with this one : Private Sub TextBox2_Change() On Error Resume Next TextBox6.Value = TextBox2.Value / 10 End Sub -- Regards, Halim " wrote: Hi, I have created a userform1 with the following: textbox2 is used to enter an amount("$0000") this is linked to sheet1 cell ("F10"). I have a formula in cell ("M10") that devides the amount entered in ("f10") by 10. I have textbox6 in the userform that displays the result by linking this to range("M10"). I am trying to get the data in textbox6 to display the result automatically however I am not too sure how to do this, I currently have it set up so that the results are displayed in the userform when I click onto the form however I am not sure how to make texbox6 auto update? can somebody please give me a suggestion? thanks Paul |
All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com