Results 1 to 3 of 3

Thread: Vba

  1. #1
    Board Regular Joesif's Avatar
    Join Date
    Feb 2010
    Location
    England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vba

    Hi

    I just wanted some advice really. I'm pretty confident with excel formulas and working but never use VBA so just wondering where I best to start to learn myself. What have other people find works best for them. Are there any good guides knocking about to look at

    Cheers
    Joe

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    10,916
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Vba

    This is just one of many websites where you can get free tutorials on VBA.

    http://www.excel-vba.com/excel-vba-s...-beginners.htm

    I am self taught and had to learn of necessity back in the twentieth century. My advice.
    1. Think logically and digitally.
    2. Get a personal project to build a code for.
    3. Draw a diagram of the steps you want the project to accomplish.
    4. Use the macro recorder to record the steps.
    5. Tie the steps together at some point to make a program.
    6. Learn how to troubleshoot the code by debugging your code and streamlining it to remove the select and activate methods that the recorder produces.
    7. Don't be ashamed to ask for advice from co-workers. We all have to learn by trial and error, even if we have a professional tutor.
    8. Don't be afraid to try code you write. The worst that can happen is making a perpetural loop or corrupting a file. Ctrl + Alt + Delete can cure most unexpected results, but it also eliminates and unsaved code.
    9. When you think you have a good understanding of how VBA works, then you can use the forums help you develop specific code and solve problems.
    10. Last but not least, learn to use the VBA help files that are accessed through the vb editor screen and if you can afford it, by a book on VBA programming.
    Last edited by JLGWhiz; Jun 24th, 2019 at 03:36 PM.
    Using Windows 10, Excel 2013.
    Any code provided by me should be tested on a copy or a mock-up of your file before applying it to your original file. Some actions generated by VBA code cannot be reversed with the undo facility in Excel. To open the VB editor, press Alt + F11. To run code from the Excel window, press Alt + F8. Please do not attempt to learn everything about VBA in one thread, especially from me. See this link for attaching images: Attachments

  3. #3
    Board Regular Joesif's Avatar
    Join Date
    Feb 2010
    Location
    England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vba

    Thanks for the reply some great advice for me to start with

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •