Introduction to Visual Basic for Applications (VBA) in Excel
Main.VbaMacro History
Hide minor edits - Show changes to output
Deleted lines 17-35:
----
(: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:)
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:)
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:
Added lines 12-13:
This same example problem is also demonstrated with [[Main/MatlabProgram|MATLAB]] and in the [[Main/PythonProgram|Python programming language]]
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 = '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:)
(: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:)