Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Upload your resume securely at https://www.dwsimpson.com
to be contacted when our jobs meet your skills and objectives.


View Poll Results: What is the best way to learn VBA?
Book 108 36.24%
Help 48 16.11%
Internet 149 50.00%
Macro Recorder 113 37.92%
Multiple Choice Poll. Voters: 298. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #11  
Old 08-09-2006, 11:55 PM
IMP's Avatar
IMP IMP is offline
= I Must Pass
 
Join Date: Mar 2004
Location: in my pants, and yours
Studying for drinking
Favorite beer: blue moon....cuz i'm a female
Posts: 31,682
Blog Entries: 11
Default

oops, i took the poll before i read the post. i voted help, meaning live help from coworkers.
__________________
Quote:
Originally Posted by Patience View Post
that's why they invented doggy style
Reply With Quote
  #12  
Old 08-09-2006, 11:57 PM
Bama Gambler's Avatar
Bama Gambler Bama Gambler is offline
James Washer / Notes Contributor
SOA
 
Join Date: Jan 2002
Location: B'ham, AL
Posts: 17,188
Default

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.
__________________

We help people pass actuarial exams.

Follow us on Twitter, Facebook, and LinkedIn.

Reply With Quote
  #13  
Old 08-10-2006, 12:06 AM
Griffin 1's Avatar
Griffin 1 Griffin 1 is offline
Member
 
Join Date: Sep 2001
Location: This is the worst kind of discrimination. The kind against me.
Favorite beer: Grizzly. No, wait - polar bears.
Posts: 10,485
Default

Quote:
Originally Posted by Bama Gambler View Post
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.
How about just leaving at "what works for one person may not work for another", since many people who are just as knowledgeable and skilled in VB and VBA as you would disagree?
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about.
Reply With Quote
  #14  
Old 08-10-2006, 09:16 AM
Bama Gambler's Avatar
Bama Gambler Bama Gambler is offline
James Washer / Notes Contributor
SOA
 
Join Date: Jan 2002
Location: B'ham, AL
Posts: 17,188
Default

Quote:
Originally Posted by Griffin 1 View Post
How about just leaving at "what works for one person may not work for another", since many people who are just as knowledgeable and skilled in VB and VBA as you would disagree?
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.
__________________

We help people pass actuarial exams.

Follow us on Twitter, Facebook, and LinkedIn.

Reply With Quote
  #15  
Old 08-10-2006, 09:24 AM
MNBridge's Avatar
MNBridge MNBridge is offline
Site Supporter
Site Supporter
 
Join Date: Jan 2002
Posts: 8,366
Default

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.
Reply With Quote
  #16  
Old 08-10-2006, 09:28 AM
Bama Gambler's Avatar
Bama Gambler Bama Gambler is offline
James Washer / Notes Contributor
SOA
 
Join Date: Jan 2002
Location: B'ham, AL
Posts: 17,188
Default

MNB, we can do that for you here too.
__________________

We help people pass actuarial exams.

Follow us on Twitter, Facebook, and LinkedIn.

Reply With Quote
  #17  
Old 08-10-2006, 09:30 AM
MNBridge's Avatar
MNBridge MNBridge is offline
Site Supporter
Site Supporter
 
Join Date: Jan 2002
Posts: 8,366
Default

Quote:
Originally Posted by Bama Gambler View Post
MNB, we can do that for you here too.
Yes, I often use this site as well and cross post.
Reply With Quote
  #18  
Old 08-10-2006, 09:30 AM
Bama Gambler's Avatar
Bama Gambler Bama Gambler is offline
James Washer / Notes Contributor
SOA
 
Join Date: Jan 2002
Location: B'ham, AL
Posts: 17,188
Default

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 09:33 AM.. Reason: Couldn't figure a good way to word that last sentence w/o offending anyone
Reply With Quote
  #19  
Old 08-10-2006, 09:37 AM
Bama Gambler's Avatar
Bama Gambler Bama Gambler is offline
James Washer / Notes Contributor
SOA
 
Join Date: Jan 2002
Location: B'ham, AL
Posts: 17,188
Default

To those who voted for macro recorder - have you read an Excel VBA book? If so, which book?
__________________

We help people pass actuarial exams.

Follow us on Twitter, Facebook, and LinkedIn.

Reply With Quote
  #20  
Old 08-10-2006, 09:41 AM
MNBridge's Avatar
MNBridge MNBridge is offline
Site Supporter
Site Supporter
 
Join Date: Jan 2002
Posts: 8,366
Default

Quote:
Originally Posted by Bama Gambler View Post
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?
Here I think the question becomes, at what level?

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 09:51 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.33884 seconds with 10 queries