ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform textbox help (https://www.excelbanter.com/excel-programming/373050-userform-textbox-help.html)

[email protected]

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



All times are GMT +1. The time now is 08:47 AM.

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