• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need a Quick Reference Guide

P

PiggyPowell_90

New Member
Hey guys, I'm in need of a website or file that shows a large amount of commonly used commands/code in Excel VBA. It is getting tedious to specifically search or record a Macro of what I am attempting to do, or having to look off of old Macros to figure out just the syntax. I'm sure it will come with time and repetition but a quick look sort of guide would help me out tremendously. If anyone could point me in the right direction I'd appreciate it
 
For syntax, type a method/object into the VBE and then press F1. This will bring up the help file on that item, and show you what you need or what is optioinal. Beyond that, I'd recommend searching this forum for "VBA training". There's a few threads about good books to read, as well as Chandoo's article to get you started:

http://chandoo.org/wp/excel-vba/videos/
 
 

Microsoft Excel Visual Basic Reference :


http://msdn.microsoft.com/en-us/library/office/aa272254%28v=office.11%29.aspx
 
You must log in or register to reply here.
Back
Top