• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • 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

  • Soma de TextBox Complicada bravesa Ingles.png
    Soma de TextBox Complicada bravesa Ingles.png
    200.1 KB · Views: 2
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.
 
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.
 
Back
Top