Choose your language

Do Loop Sum

Basic Exercise


Statement

Create an Inputbox within a Do Loop to access value additions, as if it is a calculator just for additions. Make the loop show the final value of the addition at the end, when the user clicks the ok button with an empty input. Additionally, if a text character is inserted, make it so that a message appears instructing the user to input only numeric values. This alert message should not make the application lose the previously inserted values.


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Create two conditionals If within the Do Loop to identify if a value is numeric or null.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape