locked
keen to learn visual basic programming with excel RRS feed

  • Question

  • Hi ,

     

    I have the knowledge of excel and minimal knowledge about recording macro, creating buttons , forms & using formulas.

    I want learn Visual basic as a beginner and gain in depth knowledge to use the same in Excel.

    want to know about any online trainings. Please help.

     

    Thank you.

    Krishna.

    Friday, January 21, 2011 11:24 AM

Answers

  • Hi,

    Good to hear you want to start getting familiarized with VB and VBA. In your case i'd recommend first creating macro's with the macro recorder in Excel. Create a couple and look at the VBA code which Excel creates. You can view this by going to the macro and choosing edit or press ALT-F11 and look at the modules that are created. Everyone who wants to start with VBA should use this technique first. It shows you the various objects being used. You'll get an insight in how the flow works. For instance create a macro that places your name in a cel and makes the cell red. See what the recorder makes of this. Try to read it, adjust the color and run the macro again.

    Office has it's own enige the VBA engine. Although lots of VB code will run in VBA as well some code won't.

    If you perform a search for Excel and VBA tutorial you'll find lots of materials to start with. The next step you could do is combining the two in Visual Studio Tools for Office. In that environment you will be attacking Excel via Visual Studio. Takes a little more effort because you need more resources to get started.

    Some gurus in excel: John Walkenbach, Chip Pearson

    www.j-walk.com

    www.cpearson.com

    maurice


    Maurice
    • Marked as answer by Rubel Khan Friday, February 4, 2011 6:08 PM
    Friday, January 21, 2011 1:09 PM

All replies

  • Hi,

    Good to hear you want to start getting familiarized with VB and VBA. In your case i'd recommend first creating macro's with the macro recorder in Excel. Create a couple and look at the VBA code which Excel creates. You can view this by going to the macro and choosing edit or press ALT-F11 and look at the modules that are created. Everyone who wants to start with VBA should use this technique first. It shows you the various objects being used. You'll get an insight in how the flow works. For instance create a macro that places your name in a cel and makes the cell red. See what the recorder makes of this. Try to read it, adjust the color and run the macro again.

    Office has it's own enige the VBA engine. Although lots of VB code will run in VBA as well some code won't.

    If you perform a search for Excel and VBA tutorial you'll find lots of materials to start with. The next step you could do is combining the two in Visual Studio Tools for Office. In that environment you will be attacking Excel via Visual Studio. Takes a little more effort because you need more resources to get started.

    Some gurus in excel: John Walkenbach, Chip Pearson

    www.j-walk.com

    www.cpearson.com

    maurice


    Maurice
    • Marked as answer by Rubel Khan Friday, February 4, 2011 6:08 PM
    Friday, January 21, 2011 1:09 PM
  • Learning how to write VBA V7 macros in an EXCEL 2010 spreadsheet.

    The internet is full of older videos and text courses. Is there any tutorial you can recommend.

     

    I used the EXCEL 2010 HELP and found : Welcome to the Visual Basic for Applications Language Reference for Microsoft Office 2010

    This documentation is accessible from the following locations:

    • From the product.  To view the developer reference from inside your installed version of any Microsoft Office client, click Help. In the Search list, under Content from this Computer, click Developer Reference.
    • From the Microsoft Download Center.  To download the latest version of the Developer Reference for offline viewing, and to update local copies for use with the product, visit the Microsoft Download Center.
    • From the MSDN Library.  To view the most recent version online, click items in the table of contents control, displayed in the navigation pane of your browser.

    A great reference document.


    Bill Smith 250-386-9926
    Tuesday, February 22, 2011 5:25 PM