Notes And Soft: vba tips and tricks

Excel VBA and Macro Programming For Absolute Beginners course

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtLHtarXl8B6ABPBg3MET3oUuvuiILBLjY6thjfGT9cDcPYWMha_19oFur2-HzwkVNy-HWK7GpQGBmwf8iExe3VMIcUjDF1wzX-2xWwIx0_aFXHbzW7Q0fzo8Z2UcJC85APe83V2Kkrmg/s1600/Excel+VBA+for+10+dollars.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtLHtarXl8B6ABPBg3MET3oUuvuiILBLjY6thjfGT9cDcPYWMha_19oFur2-HzwkVNy-HWK7GpQGBmwf8iExe3VMIcUjDF1wzX-2xWwIx0_aFXHbzW7Q0fzo8Z2UcJC85APe83V2Kkrmg/s200/Excel+VBA+for+10+dollars.jpg" width="200" /></a></div>
<br />
<h3 class="tab-title" style="background-color: #f4f4f4; box-sizing: border-box; color: #353535; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 1.2; margin-bottom: 10px; margin-top: 20px;">
Course Description</h3>
<div class="js-simple-collapse" data-more="Full details" style="background-color: #f4f4f4; box-sizing: border-box; color: #353535; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; max-height: none; overflow: hidden; position: relative;">
<div class="js-simple-collapse-inner" style="box-sizing: border-box;">
<div style="box-sizing: border-box; margin-bottom: 15px;">
<strong style="box-sizing: border-box;"><em style="box-sizing: border-box;">Did you know that repetition is a curse,</em></strong> if you don't stop then you'll be wasting thousands of hours of your life. As an Excel user, you know that many times you create same sheet, with same formatting and same formulas, again and again. So, you're wasting thousands of hours, which you can spend with your family, or doing other important stuff.</div>
<div style="box-sizing: border-box; margin-bottom: 15px;">
<div style="text-align: center;">
Luckily, there is a tool or a language using which you can save those thousand hours of your life by creating a simple program which does the work for you. The program will create the sheet for you, it'll format it for you and it'll insert the formulas you. Not just that It'll protect your data in different ways.</div>
</div>
<div style="box-sizing: border-box; margin-bottom: 15px;">
<div style="text-align: center;">
Excel VBA, the programming language we're going to learn in this course which'll help you automate your daily tasks more smarter and more easier. You'll be able to tackle different and complicated situations easier.</div>
</div>
<div style="box-sizing: border-box; margin-bottom: 15px;">
<div style="text-align: center;">
So, don't waste anymore hour or second of your life and take this course immediately, uncover the tools which'll make your life easier.</div>
</div>
</div>
</div>
<div class="top-space-for-scroll" id="requirements" style="background-color: #f4f4f4; box-sizing: border-box; color: #353535; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 1.6; margin-bottom: -50px; padding-top: 60px;">
<h3>
What are the requirements?</h3>
<ul class="regular-list" style="box-sizing: border-box; margin: 0px 0px 0px 10px; padding: 0px 0px 0px 10px;">
<li style="box-sizing: border-box;">Just basic knowledge of Excel</li>
</ul>
</div>
<div class="top-space-for-scroll" id="what-you-get" style="background-color: #f4f4f4; box-sizing: border-box; color: #353535; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 1.6; margin-bottom: -50px; padding-top: 60px;">
<h3 class="tab-title" style="box-sizing: border-box; color: inherit; font-family: inherit; font-size: 15px; line-height: 1.2; margin-bottom: 10px; margin-top: 20px;">
What am I going to get from this course?</h3>
<ul class="regular-list" style="box-sizing: border-box; margin: 0px 0px 0px 10px; padding: 0px 0px 0px 10px;">
<li style="box-sizing: border-box;">Over 24 lectures and 1.5 hours of content!</li>
<li style="box-sizing: border-box;">Tackle complicated Excel situations Easily</li>
<li style="box-sizing: border-box;">Automate Excel and make it do all the work for you</li>
<li style="box-sizing: border-box;">Save thousands of hours of your life</li>
</ul>
</div>
<div class="top-space-for-scroll" id="who-should-attend" style="background-color: #f4f4f4; box-sizing: border-box; color: #353535; font-family: 'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 21.4286px; margin-bottom: -50px; padding-top: 60px;">
<h3 class="tab-title" style="box-sizing: border-box; color: inherit; font-family: inherit; font-size: 15px; line-height: 1.2; margin-bottom: 10px; margin-top: 20px;">
What is the target audience?</h3>
<ul class="regular-list" style="box-sizing: border-box; margin: 0px 0px 0px 10px; padding: 0px 0px 0px 10px;">
<li style="box-sizing: border-box;">It is for one who wants to learn how powerful VBA is.</li>
<li style="box-sizing: border-box;">It is for one who is tired of limitations of Excel.</li>
</ul>
</div>
<div dir="ltr" style="text-align: left;" trbidi="on">
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<br />
<ins class="adsbygoogle" data-ad-client="ca-pub-4861872728500410" data-ad-slot="3693836080" style="display: inline-block; height: 280px; width: 336px;"></ins><script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
</div>

Excel VBA and Macro Programming For Absolute Beginners course

Course Description Did you know that repetition is a curse, if you don't stop then you'll be wasting thousands of hours ...

Excel VBA Tips n Tricks # 5 | How to protect your VBA Code

<div class="separator" style="clear: both; text-align: center;display:none;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiRYgbdgWQiGT1XgyKB7tSChyphenhyphenIItQRZbFmPuIudoCRUz67yn6MGL5hCcoqd3_Fgzb1PhpuWn-mP044zfUutdhtvG4_8s7Zf10cJTDyUzCSrfppwbP5puD8Klvak3UXxqJK4HiwbU3Ewvc/s1600/Tips+and+Tricks+Protect+VBA+Code.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiRYgbdgWQiGT1XgyKB7tSChyphenhyphenIItQRZbFmPuIudoCRUz67yn6MGL5hCcoqd3_Fgzb1PhpuWn-mP044zfUutdhtvG4_8s7Zf10cJTDyUzCSrfppwbP5puD8Klvak3UXxqJK4HiwbU3Ewvc/s320/Tips+and+Tricks+Protect+VBA+Code.jpg" /></a></div>
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
In this excel vba tips and tricks tutorial # 5 ,we're going to be learning how to protect our VBA code with password.</div>
<br />
<br />
<center>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/jYCXmNSiECM" width="560"></iframe>
</center>
<br />
<br />
<center>
<iframe allowfullscreen="" frameborder="0" height="315" src="//www.dailymotion.com/embed/video/x2map83?logo=0" width="560"></iframe>
</center>
</div>
<br/>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-4861872728500410"
     data-ad-slot="3693836080"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

Excel VBA Tips n Tricks # 5 | How to protect your VBA Code

In this excel vba tips and tricks tutorial # 5 ,we're going to be learning how to protect our VBA code with password. ...

Excel VBA Tips n Tricks #4 | Running VBA code faster with Screen Updating Method

<div class="separator" style="clear: both; text-align: center;display:none;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxE5GH139mAaBDlyNnklWZGlreibQiSa6ZpkXpdC5sWQM9oQb-O1jkL1s6nzoIIXpshdCS0rzh-q8TsEQRZgIopqRtq_A2EuZbn-kfHBeWRb-wSeG0pZiiVXXpRDBtG1qMcUaIadh7coM/s1600/Tips+and+Tricks+Screenupdating.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxE5GH139mAaBDlyNnklWZGlreibQiSa6ZpkXpdC5sWQM9oQb-O1jkL1s6nzoIIXpshdCS0rzh-q8TsEQRZgIopqRtq_A2EuZbn-kfHBeWRb-wSeG0pZiiVXXpRDBtG1qMcUaIadh7coM/s320/Tips+and+Tricks+Screenupdating.jpg" /></a></div>
<div dir="ltr" style="text-align: left;" trbidi="on">
In this excel vba programming tips and tricks tutorial # 4, we are going
 to be learning how we can make our vba code faster or in other words 
how can we optimize our vba code,<br />and the solution for Running vba code faster is using Screen Updating method</div>
<br/>
<br/>
<center>
<iframe width="560" height="315" src="https://www.youtube.com/embed/kuy1bhmbfjA" frameborder="0" allowfullscreen></iframe>
</center>
<br/>
<br/>
<center>
<iframe frameborder="0" width="560" height="315" src="//www.dailymotion.com/embed/video/x2m53eg?logo=0" allowfullscreen></iframe>
</center>
<br/>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-4861872728500410"
     data-ad-slot="3693836080"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

Excel VBA Tips n Tricks #4 | Running VBA code faster with Screen Updating Method

In this excel vba programming tips and tricks tutorial # 4, we are going to be learning how we can make our vba code faster or in other w...

Excel VBA Tips n Tricks #3 | Create and save all your macros in a Personal workbook

<div class="separator" style="clear: both; text-align: center;display:none;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfqLTq8iGnfVG6Z0ZEDPhU7OZpLGhgm5d-JpB2x13ZoLnWDBpxMEREMt189igr9jgcK7Mug9TilKFJsMiUCKC3mAn3LRAbKiRpMZefrGqAAzVXiZ2uvuhWOHBefs_cuDv8uoW5d2Iwy6w/s1600/Tips+and+Tricks+Personal+Workbook.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfqLTq8iGnfVG6Z0ZEDPhU7OZpLGhgm5d-JpB2x13ZoLnWDBpxMEREMt189igr9jgcK7Mug9TilKFJsMiUCKC3mAn3LRAbKiRpMZefrGqAAzVXiZ2uvuhWOHBefs_cuDv8uoW5d2Iwy6w/s320/Tips+and+Tricks+Personal+Workbook.jpg" /></a></div>
<div dir="ltr" style="text-align: left;" trbidi="on">
In this excel vba programming tips and tricks tutorial # 3, we will be 
create and save all of your macros in a single workbook called personal 
workbook.<br />
</div>
<br/>
<br/>
<center>
<iframe width="560" height="315" src="https://www.youtube.com/embed/HExdZjSA41U" frameborder="0" allowfullscreen></iframe>
</center>
<br/>
<br/>
<center>
<iframe frameborder="0" width="560" height="315" src="//www.dailymotion.com/embed/video/x2ljkos?logo=0" allowfullscreen></iframe>
</center>
<br/>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-4861872728500410"
     data-ad-slot="3693836080"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

Excel VBA Tips n Tricks #3 | Create and save all your macros in a Personal workbook

In this excel vba programming tips and tricks tutorial # 3, we will be create and save all of your macros in a single workbook called per...

Excel VBA Programming Tips n Tricks # 2 | How to use Excel formulas in VBA

<div class="separator" style="clear: both; text-align: center;display:none;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_y8GqO8Grg8Sf1uCr2ed2jrUNMihfw9hQyy0VGWjkSFwX8hCJ8nvl_D0C-oMGE8XHWDy7s7fHxUuCGwhyaK-q5EvEJh0RbjkwFkqCyVVpasgpK0PYTxbDzpA2XZnKG45CQWdV2jTOn1A/s1600/Tips+and+Tricks+Use+Excel+Formulas.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_y8GqO8Grg8Sf1uCr2ed2jrUNMihfw9hQyy0VGWjkSFwX8hCJ8nvl_D0C-oMGE8XHWDy7s7fHxUuCGwhyaK-q5EvEJh0RbjkwFkqCyVVpasgpK0PYTxbDzpA2XZnKG45CQWdV2jTOn1A/s320/Tips+and+Tricks+Use+Excel+Formulas.jpg" /></a></div>
<div dir="ltr" style="text-align: left;" trbidi="on">
In this excel vba programming tips and tricks tutorial # 2, we will be learning how to use the built-in Excel formulas in VBA.<br />And we will be using two methods that are:<br />1: Range("A17").formula="=su<br />
<div id="eow-description">
<wbr></wbr>m(a1:a16)"<br />2: Range("A17").value = Application.worksheetfunction.sum(Range(<wbr></wbr>"a1:a16"))</div>
<div id="eow-description">
<br /></div>
<div id="eow-description">
<br /></div>
</div>
<br/>
<br/>
<center>
<iframe width="560" height="315" src="https://www.youtube.com/embed/gh1rFBYBo0k" frameborder="0" allowfullscreen></iframe>
</center>

<br/>
<br/>
<center>
<iframe frameborder="0" width="560" height="315" src="//www.dailymotion.com/embed/video/x2l8rsu?logo=0" allowfullscreen></iframe>
</center>
<br/>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-4861872728500410"
     data-ad-slot="3693836080"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

Excel VBA Programming Tips n Tricks # 2 | How to use Excel formulas in VBA

In this excel vba programming tips and tricks tutorial # 2, we will be learning how to use the built-in Excel formulas in VBA. And we will...

Excel VBA Programming Tips n Tricks #1 | Get the Name of all worksheets

<div class="separator" style="clear: both; text-align: center;display:none;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW2mYmZxaedshgHfPSFl5zR0wLj_c4YNrEGi9GRg__nmC8gsco0VfDgUlOC_LSJkL-Yxvjv0wIXsv1BLSpsrnCs-LXZqLQcOnSe7_DosqIDqjq5TPHjW1BqK8IxDmbcO2hGOazzHEQJYA/s1600/Tips+and+Tricks+Names+of+all+worksheets.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiW2mYmZxaedshgHfPSFl5zR0wLj_c4YNrEGi9GRg__nmC8gsco0VfDgUlOC_LSJkL-Yxvjv0wIXsv1BLSpsrnCs-LXZqLQcOnSe7_DosqIDqjq5TPHjW1BqK8IxDmbcO2hGOazzHEQJYA/s320/Tips+and+Tricks+Names+of+all+worksheets.jpg" /></a></div>
<div dir="ltr" style="text-align: left;" trbidi="on">
In this Excel VBA Programming Tips and Tricks #1 tutorial we're going to
 learn how to get the names of all worksheets in our combo Box.<br />
<br />
<center>
<iframe allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/IZ2zaYx-79k" width="560"></iframe>
</center>
<br />
<h3 style="text-align: left;">
Dailymotion Video:</h3>
<br />
<center>
<iframe allowfullscreen="" frameborder="0" height="315" src="//www.dailymotion.com/embed/video/x2krqmw?logo=0" width="560"></iframe>
</center>
</div>
<br/>
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-4861872728500410"
     data-ad-slot="3693836080"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>

Excel VBA Programming Tips n Tricks #1 | Get the Name of all worksheets

In this Excel VBA Programming Tips and Tricks #1 tutorial we're going to learn how to get the names of all worksheets in our combo Bo...