Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Learning VB for excel

  • 01-07-2011 08:22AM
    #1
    hotshots85
    Registered Users, Registered Users 2 Posts: 342 ✭✭


    Hi All,


    I'm a complete begnner to any kind of programming but am looking itno learning some Visual Basic. I want to use it for my job to build macros and the likes to speed up some process.

    What the best way to start? Learning VB form the ground up or leanr it specifcally for excel? Any good ideas for source material?


    Cheers

    Hotshots


Comments

  • #2
    Taltos
    Registered Users, Registered Users 2 Posts: 20,830 ✭✭✭✭Taltos


    A simple way is to start recording simple macros - then go in an start making simple changes or even just walk through the code using F8 so you can watch how it moved through the code.

    Also - google is your friend here....


  • #3
    HivemindXX
    Registered Users, Registered Users 2 Posts: 1,208 ✭✭✭HivemindXX


    Don't try to learn Visual Basic, meaning either VB6 or VB.NET. The version used in Excel (and Access and Word) is called VBA which stands for Visual Basic for Applications. It's pretty similar but why learn the wrong thing and then get caught out by one of the differences. Once you know VBA moving to VB.NET is basically a question of learning the .Net framework.

    Taltos suggestion to record macros is a good one. A basic rule of thumb is that anything (with some exceptions mostly to do with security) you can do through the user interface you can automate with VBA.

    John Walkenbach's book is excellent. I have a pretty old version but this is a link to the current version.
    http://www.amazon.co.uk/Excel-Power-Programming-Spreadsheets-Bookshelf/dp/0470044012/ref=sr_1_3?ie=UTF8&qid=1309509334&sr=8-3

    There's also a great range of helpful web sites for Excel programming. Here's a selection.
    http://spreadsheetpage.com/
    http://www.mrexcel.com/articles.shtml
    http://www.ozgrid.com/free-excel.htm


Advertisement