![]() |
|
|
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.62% |
Help |
![]() ![]() ![]() ![]() |
48 | 15.69% |
Internet |
![]() ![]() ![]() ![]() |
154 | 50.33% |
Macro Recorder |
![]() ![]() ![]() ![]() |
117 | 38.24% |
Multiple Choice Poll. Voters: 306. You may not vote on this poll |
![]() |
|
Thread Tools | Search this Thread | Display Modes |
#21
|
||||
|
||||
![]() Quote:
So to someone seeking advice on how to learn VBA, I would say "Here are several different methods. Try them all out and see what works best for you."
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about. |
#22
|
||||
|
||||
![]() Quote:
I haven't really 'read' it, though I should. But I use Walkenbach's book for reference consistently. |
#23
|
||||
|
||||
![]() 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 comes in handy if you or anyone else ever needs to make changes to the code.
|
#24
|
||||
|
||||
![]() Quote:
Quote:
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about. |
#25
|
||||
|
||||
![]() 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. ![]() |
#26
|
||||
|
||||
![]() Quote:
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about. |
#27
|
|||
|
|||
![]() I have learned VBA trough VB (i took a VB class in university), which gave me the basics only for VBA. As you get better, HELP will be your best friend.
Or just write VBA in google and you'll get a thousand forums talking about VBA, functions, etc. |
#28
|
||||
|
||||
![]() And you quickly learn to identify which sites will, after you've gotten there, say "Want the answer to this question? Pay us some money!"
__________________
I've never heard of such a brutal and shocking injustice that I cared so little about. |
#29
|
|||
|
|||
![]() I've never read a VBA book. yet i know about cells(r,c). I started by recording macros, and adding in the various loops as needed. As so an i needed to loop through various cells (even down rows as opposed to columns) I knew there had to be some sort of cells(r,c). Now I use the help files when needed, and I still will read through other peoples code from time to time to see how they tackle the problems.
__________________
John 3:16 |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|