learning VBA

[alexw123]

Hi guys,

I've been using excel for the past year in my current job and have built up a good knowledge of formulas and functions to an intermediate level. I'm really interested to learn more about excel and VBA in particular. I have a degree in business so VBA and coding in general is quite new to me but i feel like its something i would enjoy career wise.

I'm interested in your opinions on how best to learn VBA. I know there's alot of youtube videos ect but I'm wondering if i could get to a good level (eg. somebody who has a computer science degree) by this means alone? or would paying for lessons with a tutor be better?

Also another question (maybe not relevant to this thread) but i'm also wondering how useful a good knowledge of VBA will be in a career in finance? And also what kind of careers learning VBA could open up.

Anyway sorry to ramble, any advice would be appreciated!

Thanks
Alex

 

[hiker95]

leeboy168,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

 

[DocAElstein]

@ hiker95

Thanks hiker for the update and very extensive list! One well worth archiving!

Alan

_ ........................................................

BTW. @

.,...
I'm interested in your opinions on how best to learn VBA. I know there's alot of youtube videos ect but I'm wondering if i could get to a good level ...... any advice would be appreciated!....
Alex

@ alexw123 and leeboy168

I agree with what you will hear a lot from experienced users l.. At the end of the day, practice and practice and more practice and participation in Forums like these is the best way to learn – I have learnt the most in answering and contributing to Threads here . I did find it occasionally, as an addition, useful to have a good selection of Playlist from the You Tube Videos. I Let them run in the background, or as an alternative to the Telly to fall asleep to!


Sometimes the Links change at You Tube. If that happens you could do a Google search with “You Tube” and these names

YourProgrammingNetwork
ExcelVbalsFun
WiseOwlTutorials
ExcelScreencasts
ExcelVBAHelp
Andreas Thehos
LoeblComServices
Dinesh Kumar Takyar
VBA4Excel
I-Helped-U DoubleCheck
methodactor1982VBA

_ .. and try to find their playlists.

_ ....These links seem to be working just now:

https://www.youtube.com/watch?v=ABXPb0qnKUY&list=PLS7iHfqXNVhK3yzd_4XS5k4zsvnu2mkJC
https://www.youtube.com/watch?v=KHO5NIcZAc4&list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5
https://www.youtube.com/watch?v=kd6Z9Pu0Log&list=PLRvJRREE9cUmR8GUwdAVH5Dq42RG9tlRP
https://www.youtube.com/watch?v=AIhKNNXzZLM&list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR
https://www.youtube.com/watch?v=Z08z5Jx2U2A&list=PLw8O1w0Hv2zsPU-k2vPZ_6brD5Gk1sVy_
https://www.youtube.com/user/ExcelVbaIsFun/playlists
https://www.youtube.com/watch?v=o_d8XO27HA8&list=PLrmbflR_3N5LDxq7WUMlhXL_9m7EAgcMq
https://www.youtube.com/user/ExcelVBAHelp/playlists?shelf_id=2&sort=dd&view=50
https://www.youtube.com/playlist?list=PLVA_smmo8_F1yiam5Cno2SEPBLLPGOyBz
https://www.youtube.com/watch?v=y_1enOnE29Y&list=PL3A6U40JUYCiXTl777-7lleNVtNeAhBVC
https://www.youtube.com/watch?v=CDYkKYvuckA&list=PL13007E847B3E6658

Alan


P.s.

Some other Threads where VBA learning was discussed
http://www.mrexcel.com/forum/genera...-visual-basic-applications-code-writting.html
http://www.mrexcel.com/forum/genera...el-visual-basic-applications.html#post3820234
How to find which worksheet my macro is launched from [SOLVED] - Page 2
How useful are YouTube tutorials for VBA

 

[hiker95]

@ hiker95

Thanks hiker for the update and very extensive list! One well worth archiving!

Alan

Alan,

Thanks for that.

And, I will update my list with your goodies.

 

[alexw123]

Hi Guys, thanks for all your responses. Hiker and Alan, thanks very much for the lists! They will both be really useful and will keep me busy! I can't say how much i appreciate complete strangers giving me a tonne of free resources to work with on VBA! I've not been a member of this forum very long but i've found that that people on here on so willing to go out of there way to help people.

Cheers for the advice Alan - i'll try and be more active / participate more on here. Hopefully i can get to a level where I will actually be of some use!

Merry Christmas and thanks again!

Alex

 

[DocAElstein]

Hi Alex

Hi Guys, thanks for all your responses. Hiker and Alan,....

Yous very welcome. Gald we could help
Good luck with learning
Merry Xmas
Alan

 

[hiker95]

alexw123,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.

Merry Christmas, and, a Happy New Year.