Main

Introduction to Visual Basic for Applications (VBA) in Excel

Main.VbaMacro History

Hide minor edits - Show changes to output

January 05, 2017, at 01:04 AM by 10.10.144.119 -
Changed line 8 from:
<iframe width="560" height="315" src="https://www.youtube.com/embed/h2MeXqhl8FE" frameborder="0" allowfullscreen></iframe>
to:
<iframe width="560" height="315" src="https://www.youtube.com/embed/bHwFTDp5g6A" frameborder="0" allowfullscreen></iframe>
Added lines 6-9:

(:html:)
<iframe width="560" height="315" src="https://www.youtube.com/embed/h2MeXqhl8FE" frameborder="0" allowfullscreen></iframe>
(:htmlend:)
May 14, 2014, at 10:11 PM by 10.5.113.178 -
Changed line 1 from:
(:title Computational Tools for Engineers - Introduction to Visual Basic for Applications (VBA) in Excel:)
to:
(:title Introduction to Visual Basic for Applications (VBA) in Excel:)
Deleted lines 4-5:
!!!!Introduction to Visual Basic for Applications (VBA) in Excel
Added lines 12-13:

This same example problem is also demonstrated with [[Main/MatlabProgram|MATLAB]] and in the [[Main/PythonProgram|Python programming language]]
May 10, 2014, at 11:40 PM by 107.188.175.164 -
Added lines 1-32:
(:title Computational Tools for Engineers - Introduction to Visual Basic for Applications (VBA) in Excel:)
(:keywords introduction, VBA, Visual Basic for Applications, Microsoft Excel, spreadsheet, nonlinear, optimization, engineering optimization, university course:)
(:description Introduction to VBA in Excel - Problem-Solving Techniques for Chemical Engineers at Brigham Young University:)

!!!!Introduction to Visual Basic for Applications (VBA) in Excel

Visual Basic for Applications can be used to extend the capabilities of Excel with custom calculations. Microsoft Excel itself is not a programming language but does include an integrated development environment for recording and running macros (VBA environment). Excel macros are a series of commands that can be repeated to operate repeatedly on sets of data.

Below is an example problem that demonstrates whether a tank of particular dimensions will overflow with a certain amount of time. The tutorial shows how to import data from the worksheet, perform volume calculations, determine whether the tank will overflow with an IF statement, print out a message box, and export the volume values to the active worksheet.

(:html:)
<iframe width="560" height="315" src="//www.youtube.com/embed/0C6QMin5OZc" frameborder="0" allowfullscreen></iframe>
(:htmlend:)

----

(:html:)
 <div id="disqus_thread"></div>
    <script type="text/javascript">
        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
        var disqus_shortname = 'apmonitor'; // required: replace example with your forum shortname

        /* * * DON'T EDIT BELOW THIS LINE * * */
        (function() {
            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
            dsq.src = 'http://' + disqus_shortname + '.disqus.com/embed.js';
            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
        })();
    </script>
    <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
    <a href="http://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)