Actuarial Outpost
 
Go Back   Actuarial Outpost > Search Forums
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Showing results 1 to 13 of 13
Search took 0.00 seconds.
Search: Posts Made By: Bama Gambler
Forum: Software & Technology 08-10-2006, 01:02 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
lol, I'm not sure what version of help you have...

lol, I'm not sure what version of help you have installed, but I get the following.

For...Next Statement Example
This example uses the For...Next statement to create a string that contains 10...
Forum: Software & Technology 08-10-2006, 09:48 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
Alright, I'm giving up. It doesn't look like I'm...

Alright, I'm giving up. It doesn't look like I'm going to change anyone's mind and I'm sure not changing my mind. So we will have to agree to disagree on this one.

Till next time. :toast:
Forum: Software & Technology 08-10-2006, 09:44 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
But trust me when I say you could have learned to...

But trust me when I say you could have learned to write those simulation macros and building functions much quicker if you have started with a book. AND they would have been much cleaner code, which...
Forum: Software & Technology 08-10-2006, 09:37 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
To those who voted for macro recorder - have you...

To those who voted for macro recorder - have you read an Excel VBA book? If so, which book?
Forum: Software & Technology 08-10-2006, 09:30 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
Btw, I want to remind everyone the question isn't...

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?
Forum: Software & Technology 08-10-2006, 09:28 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
MNB, we can do that for you here too. :)

MNB, we can do that for you here too. :)
Forum: Software & Technology 08-10-2006, 09:16 AM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
Normally I would concede that. In fact, all my...

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...
Forum: Software & Technology 08-09-2006, 11:57 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
Bottom Line If you have never used Excel VBA,...

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...
Forum: Software & Technology 08-09-2006, 11:44 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
I know actuaries are smart, but you'll never find...

I know actuaries are smart, but you'll never find Cells(r,c) in a recorded macro. I use that more than anything else and I learned it from a book (or online, can't remember which). Most of the...
Forum: Software & Technology 08-09-2006, 09:40 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
whisper, why do you consider the macro recorder a...

whisper, why do you consider the macro recorder a good learning tool for vba? This is a sincere question. You've contributed to many a VBA questions over the years on this forum.
Forum: Software & Technology 08-09-2006, 06:54 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
For example, if someone was to learn using the...

For example, if someone was to learn using the macro recorder then .Select would be all throughout their code. They wouldn't learn how to declare variables, create functions, or useful things like...
Forum: Software & Technology 08-09-2006, 06:49 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
For those voting for macro recorder, can you say...

For those voting for macro recorder, can you say why you believe it's a good way to LEARN vba? I agree it's a good tool for those who already have a good foundation in vba, but to use it as a...
Forum: Software & Technology 08-09-2006, 05:26 PM
Replies: 141
Sticky: Poll: Best way to learn VBA.
Views: 208,377
Posted By Bama Gambler
Best way to learn VBA.

I'll rank my choices.

1. Good book. Any of the VBA books by Walkebach...
Showing results 1 to 13 of 13

 

All times are GMT -4. The time now is 11:02 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, 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.14519 seconds with 7 queries