Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
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 35.97%
Help 48 15.84%
Internet 152 50.17%
Macro Recorder 115 37.95%
Multiple Choice Poll. Voters: 303. You may not vote on this poll

Reply
 
Thread Tools Search this Thread Display Modes
  #71  
Old 05-29-2007, 12:56 PM
wally world wally world is offline
Member
CAS
 
Join Date: Dec 2001
Location: Indiana
Posts: 2,712
Default

Others mentioned MrExcel.com as a good resource for VBA help.

I'd also mention (and maybe somebody did and I missed it) UtterAccess.com for Access questions. They also have some Excel forums, but most of the stuff there is on Access.
Reply With Quote
  #72  
Old 06-01-2007, 01:10 PM
zeroEthix zeroEthix is offline
Member
 
Join Date: Mar 2005
Posts: 2,092
Default

http://www.cesis.lv/learn/Vbasic/
Reply With Quote
  #73  
Old 06-01-2007, 09:29 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by zeroEthix View Post
Um, a word to the wise here. This is a link to learning Visual Basic 5, which has not been sold for at least ten years (VB 6 is also no longer sold or supported either!):
Quote:
You start Visual Basic from the Windows Start menu. The Visual Basic development environment itself usually appears on a submenu called Microsoft Visual Basic 5.0, although yours might be called something different due to installation differences. You will see additional programs listed on the Microsoft Visual Basic 5.0 submenu, but when you select Visual Basic 5.0 from the submenu, Visual Basic loads and appears on your screen.
Although VBA in Excel is a version of VB, this will probably be of little help. You will probably want to stick with books/articles dealing specifically with VBA, which is used with Excel, Access, other MS Office apps, AND any other commercial apps that have licensed the VBA SDK.


Brad
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #74  
Old 06-01-2007, 09:37 PM
Griffin 6's Avatar
Griffin 6 Griffin 6 is offline
Member
 
Join Date: Sep 2001
Location: You should be more ashamed of yourself than usual.
Favorite beer: 1934 World Heavyweight Champion Max Baer
Posts: 6,310
Default

Quote:
Originally Posted by Brad Gile View Post
Um, a word to the wise here. This is a link to learning Visual Basic 5, which has not been sold for at least ten years (VB 6 is also no longer sold or supported either!):
I say you should start with programming the TI-994A. Or the Sinclair ZX-81.
__________________
e-Transport, Ltda. - International Freight Forwarders
__________________
Suvarna Chemical Industries - Manufacturers of Quality Pigment Pastes and Catalyst MEKP 50 %, Cobalt Accelerator and Cobalt Octoate for the Fiberglass Reinforced Plastic Industries
__________________
CLAAS of America, Inc. - Your Harvesting Specialist
__________________
Harbor Freight Tools - America's Favorite Tool Store
Reply With Quote
  #75  
Old 06-02-2007, 07:18 PM
mark007's Avatar
mark007 mark007 is offline
Member
 
Join Date: Sep 2006
Location: Leeds, UK
Favorite beer: Stella Artois
Posts: 141
Default

Quote:
Others mentioned MrExcel.com as a good resource for VBA help.

I'd also mention (and maybe somebody did and I missed it) UtterAccess.com for Access questions. They also have some Excel forums, but most of the stuff there is on Access.
I would also add:

www.vbaexpress.com
www.ozgrid.com
www.xtremevbtalk.com

__________________
Mark Rowlinson
www.thecodenet.com


- Founding Member
Reply With Quote
  #76  
Old 07-01-2007, 12:38 PM
Alto Reed on a Tenor Sax's Avatar
Alto Reed on a Tenor Sax Alto Reed on a Tenor Sax is offline
official Troll bane
 
Join Date: Sep 2005
Favorite beer: PBR
Posts: 12,260
Default

Quote:
Originally Posted by JMO View Post
That depends. Do you mean Earth-soon or Mars-soon?
Actually, even on Mars, with a 687 day revolution, 2010 is almost a year and a half away.

On Saturn, however, with a 29 year revolution, 2010 is, like, tomorrow. So just think of it that way.
Reply With Quote
  #77  
Old 07-02-2007, 08:09 AM
JMO's Avatar
JMO JMO is offline
Carol Marler
Non-Actuary
 
Join Date: Sep 2001
Location: Back home again in Indiana
Studying for Nothing actuarial.
Posts: 37,316
Default

Quote:
Originally Posted by Alto Reed on a Tenor Sax View Post
Actually, even on Mars, with a 687 day revolution, 2010 is almost a year and a half away.

On Saturn, however, with a 29 year revolution, 2010 is, like, tomorrow. So just think of it that way.
Thanks. I was actually looking for an RN, though.
"Once upon a time, there was a Martian named Valentine Michael Smith."
__________________
Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.


My latest favorite quotes, updated Apr 5, 2018.

Spoiler:
I should keep these four permanently.
Quote:
Originally Posted by rekrap View Post
JMO is right
Quote:
Originally Posted by campbell View Post
I agree with JMO.
Quote:
Originally Posted by Westley View Post
And def agree w/ JMO.
Quote:
Originally Posted by MG View Post
This. And everything else JMO wrote.
And this all purpose permanent quote:
Quote:
Originally Posted by Dr T Non-Fan View Post
Yup, it is always someone else's fault.
MORE:
All purpose response for careers forum:
Quote:
Originally Posted by DoctorNo View Post
Depends upon the employer and the situation.
Quote:
Originally Posted by Sredni Vashtar View Post
I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.
Reply With Quote
  #78  
Old 07-03-2007, 10:02 PM
Brad Gile's Avatar
Brad Gile Brad Gile is offline
Member
CAS SOA AAA
 
Join Date: Sep 2001
Studying for whatever I feel like
College: Alumnus of Brown and UW-Madison
Posts: 11,341
Default

Quote:
Originally Posted by JMO View Post
Thanks. I was actually looking for an RN, though.
"Once upon a time, there was a Martian named Valentine Michael Smith."
I grok.
__________________
Brad Gile, FSA, MAAA
Affiliate Member of the CAS
Dedicated Retired Actuary

Spoiler:
Obama sucks and we all know it-TDA


Spoiler:

That's been the funniest subplot of this whole thing, the people on the left attacking this bill for not being even more of a steaming pile. - erosewater
Reply With Quote
  #79  
Old 07-11-2007, 05:09 AM
ejofti ejofti is offline
 
Join Date: Mar 2006
Posts: 12
Default

thanks for your advice!!
Reply With Quote
  #80  
Old 11-08-2007, 03:02 PM
Former Actuarial's Avatar
Former Actuarial Former Actuarial is offline
Member
 
Join Date: Oct 2007
Posts: 2,891
Blog Entries: 5
Default

i need to learn VBA for real now. i've gotten away with looking at previous code and manipulating it for my needs. but now i really need to learn it and use it. i'm gonna pick up Excel VBA Programming For Dummies by Walkenbach tonight. It's a 2004 version...so maybe there's something more current from him. i'm sure this one is fine if there isn't.
__________________
When I meet you in person, shots on me! Do you bite?

We are a bunch of high roller players who like to play high roller games - Hardinda
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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:09 AM.


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