• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to SUM textBox on UserForm- Excel VBA

Carlos Ferreira

New Member
I created a command button.
See what's happening.
I manually enter the values in the
TextBox Qty and PerUnit.
The TextBox value is automatically filled.
So far there is no problem.
Using the code below:
To display values in txtSub-Total. I have to press ENTER
On each txtAmount and also click on the command button.
Question: Is it possible to delete the ENTER step?
77271
 

Attachments

vletm

Excel Ninja
Carlos Ferreira
Your used textboxes are in 'edit'-mode until You'll <ENTER> ( or press <TAB> or select next something else ).
( = ... Change will work after You've changed values. )
Hint: You should able to send a sample Excel-file here.
 

vletm

Excel Ninja
Carlos Ferreira
As written
Your used textboxes are in 'edit'-mode until You'll <ENTER> ( or press <TAB> or select next something else ).
( = ... Change will work after You've changed values. )


Changes...
You try to learn to press <TAB> or <ENTER> after You've edited values in Your used textboxes.
 
Top