Supply Chain Management & Quality Management

Noah

<div>
Wow, that was fast. Thank you very much, it was what I wanted! :)
</div>


Wow, that was fast. Thank you very much, it was what I wanted! :)

<div>
You’re welcome and I’m glad I was able to help.<br />
<br />
If you expand the “Full Biography” section of <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you’ll find links to some articles I’ve written that may interest you.<br />
<br />
Marty - Microsoft MVP 2009 to 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Most Valuable Expert (MVE) 2015, 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert Visual Basic Classic 2012 to 2017<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Experts Exchange Top Expert VBA (current)
</div>


You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile [https://www.experts-exchange.com/M_258447.html] you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
              Experts Exchange Top Expert VBA (current)

<div>
<div class="content wysiwyg-content">
Hi everyone I need help writing a macro to use Excel in-built InputBox to take in 5 integers (one at a time) and store the inputs into an array. Then calculate the sum of these 5 integers and display a message like this:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/07_w29/1350128/1.jpg" target="_blank" title="1.jpg (11 KB)"><img alt="1.jpg" class="file-block lazyload" style="max-width: 348px;" data-src="https://filedb.experts-exchange.com/incoming/2018/07_w29/1350128/1.jpg" /></a><br />
Any help is much appreciated! :)
</div>
</div>


1.jpg

Hi everyone I need help writing a macro to use Excel in-built InputBox to take in 5 integers (one at a time) and store the inputs into an array. Then calculate the sum of these 5 integers and display a message like this:



Any help is much appreciated! :)

Needs Help With An Input Box that Calculates

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.