![]() |
|
#21
|
||||
|
||||
![]() Quote:
It will include tutorials and it will teach you some fundamental concepts that you will have a hard time mastering on your own, along with some best practices that are really important to pickup. Quote:
How about you find all the primes between 1 and a billion, and have them printed onto a spreadsheet? Then see if you can optimize the process so that it only takes a couple seconds to run... Or How about a Mad Lib generator, where you write a Mad Lib and then it inserts random words? Or how about a game of poker? OR OKAY, HOW about you create a VBA file that makes a flip book. Where it generates like 80 tabs, of an askii stick figure jumping up and down over and over again!
__________________
Sredni Vashtar went forth, His thoughts were red thoughts and his teeth were white. His enemies called for peace, but he brought them death. Sredni Vashtar the Beautiful. Last edited by Sredni Vashtar; 05-09-2017 at 09:21 AM.. |
#22
|
||||
|
||||
![]() Quote:
And then create a "sun" using an area chart. And then animate the chart using VBA to make the sun rises on the left side and sets on the right side while the sky changes color.
__________________
Sredni Vashtar went forth, His thoughts were red thoughts and his teeth were white. His enemies called for peace, but he brought them death. Sredni Vashtar the Beautiful. |
#23
|
||||
|
||||
![]() Quote:
To be fair, YouTube didn't exist when I got started. |
#24
|
||||
|
||||
![]() Bama Gambler makes some good points at the beginning of the sticky on learning VBA:
http://www.actuarialoutpost.com/actu...ad.php?t=88423 |
#25
|
||||
|
||||
![]() Quote:
Quote:
|
#26
|
||||
|
||||
![]() Quote:
Although an animation of the sun is pretty stupid, I would argue that Chart-Object manipulation is one of the most common things to do in VBA. Most of the time you don't really want to do your Math in VBA because you can do it in Excel. And then there's manipulating MS programs outside of Excel, but that is not a good beginner project because it can be tricky to understand the Objects.
__________________
Sredni Vashtar went forth, His thoughts were red thoughts and his teeth were white. His enemies called for peace, but he brought them death. Sredni Vashtar the Beautiful. Last edited by Sredni Vashtar; 05-09-2017 at 01:49 PM.. |
#27
|
||||
|
||||
![]() Quote:
![]() |
#28
|
||||
|
||||
![]()
__________________
Sredni Vashtar went forth, His thoughts were red thoughts and his teeth were white. His enemies called for peace, but he brought them death. Sredni Vashtar the Beautiful. |
#29
|
||||
|
||||
![]() Quote:
![]() I avoid YouTube. It's a black hole into which time gets sucked. |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|