Introduction to Visual Basic for Applications (VBA) in Excel
Main.VbaMacro History
Hide minor edits - Show changes to markup
(: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 = 'https://' + 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="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript> <a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)
<iframe width="560" height="315" src="https://www.youtube.com/embed/h2MeXqhl8FE" frameborder="0" allowfullscreen></iframe>
<iframe width="560" height="315" src="https://www.youtube.com/embed/bHwFTDp5g6A" frameborder="0" allowfullscreen></iframe>
(:html:) <iframe width="560" height="315" src="https://www.youtube.com/embed/h2MeXqhl8FE" frameborder="0" allowfullscreen></iframe> (:htmlend:)
(:title Computational Tools for Engineers - Introduction to Visual Basic for Applications (VBA) in Excel:)
(:title Introduction to Visual Basic for Applications (VBA) in Excel:)
Introduction to Visual Basic for Applications (VBA) in Excel
This same example problem is also demonstrated with MATLAB and in the Python programming language
(: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 = 'https://' + 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="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript> <a href="https://disqus.com" class="dsq-brlink">comments powered by <span class="logo-disqus">Disqus</span></a>
(:htmlend:)