![]() |
|
|
FlashChat | Actuarial Discussion | Preliminary Exams | CAS/SOA Exams | Cyberchat | Around the World | Suggestions |
View Poll Results: What is the best way to learn VBA? | |||
Book |
![]() ![]() ![]() ![]() |
109 | 36.21% |
Help |
![]() ![]() ![]() ![]() |
48 | 15.95% |
Internet |
![]() ![]() ![]() ![]() |
151 | 50.17% |
Macro Recorder |
![]() ![]() ![]() ![]() |
113 | 37.54% |
Multiple Choice Poll. Voters: 301. You may not vote on this poll |
![]() |
|
Thread Tools | Search this Thread | Display Modes |
#12
|
||||
|
||||
![]() Bottom Line
If you have never used Excel VBA, then you will pick up more useful stuff in a shorter amount of time with a good book on Excel VBA vs. playing around with the macro recorder. I don't care if you have never taken a programming class or have a Phd in computer science. It is the fastest way to learn the stuff you will actually use. The books are dirt cheap too. Hell, you can check one out at your local library for free. Now if all you need is one little macro and you don't plan to do anything else with VBA, then you can most likely find a quick and dirty solution faster with the macro recorder than reading a book. Although, in this case I'd recommend just posting the question on this forum. |
#13
|
||||
|
||||
![]() Quote:
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about. |
#14
|
||||
|
||||
![]() Normally I would concede that. In fact, all my "how to kick course X's ass" have that disclaimer, but in the case I feel too strongly. A good VBA book (vs. the macro recorder) is by far and away a much better place to start for someone that is looking to learn VBA. Why? Simple - there is tons of code for the reader to scan in the book. And guess what, that code is going to be a HELLUVA lot better than the code from the recorder. So if you learn by reading code, then read the code in a good book (vs. reading the code produced by the macro recorder). You will learn more and faster.
|
#15
|
||||
|
||||
![]() MrExcel.com is a must use site for anyone who programs in VBA.
The free advice there is unreal! I also use the VBA recorder. Here's the twist: Goto the site above and say: I used the recorder and got this, but I want to choose the column not the cell, how do I? Within 15 minutes someone will rewrite your 'recorded' macro and give you the 'proper' coding. P.S. Search is your friend there, I try not to bug them with stuff I can figure out on my own. |
#17
|
||||
|
||||
![]() Yes, I often use this site as well and cross post.
|
#18
|
||||
|
||||
![]() Btw, I want to remind everyone the question isn't what do you use to write VBA code. The question is what is the BEST way to LEARN how to use VBA?
__________________
![]() We help people pass actuarial exams. Follow us on Twitter, Facebook, and LinkedIn. ![]() Last edited by Bama Gambler; 08-10-2006 at 08:33 AM.. Reason: Couldn't figure a good way to word that last sentence w/o offending anyone |
#20
|
||||
|
||||
![]() Quote:
I used to think I was pretty good at VBA. I could generally get it to do what I wanted it to. Simulation macros Building functions (Public) etc. But my code would typically not be more than say 1 page and efficiency didn't matter. -This could be done from my 9th grade level of BASIC programming and VBA recorder. I'm quickly learning I suck at it. I have no idea why I get object errors, etc. (I really don't even know what an object is ![]() So to get to the next level I will need to get a book (or take a class) and understand the language better. I would guess 99% of all Actuaries never get to or will ever use VBA at this level. Yet many of them do consider themselves experts. This level would include stuff like: - Writing a platform for outside users that is pretty and can't be wrecked. (An outside user may not even realize they are in excel) - Building a dynamic model. (Never need to hit the 'run macro' buttons) - etc. |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|