locked
VBA Programming Reference Guide or Index RRS feed

  • Question

  • I'm looking for a comprehensive guide for a short-hand way to look up VBA object. methods, properties, etc. Something similar to what is available here under the documentation, but in print form. I don't want tutorials, just the objects, methods and properties with their parameters. Does anyone know where I can find something like this, or have a link they can pass along? 

    Tuesday, February 28, 2017 6:39 AM

Answers

All replies

  • There's the VBA Developer's Handbook by Ken Getz. I don't know how current it is, but it has a listing of all VBA Methods and their usage.

    If you search "VBA Methods PDF" you can find quite a bit of those things. For example:

    http://onlinelibrary.wiley.com/doi/10.1002/9781118093955.app6/pdf


    -- Scott McDaniel, Microsoft Access MVP

    • Proposed as answer by Chenchen Li Wednesday, March 1, 2017 2:09 AM
    Tuesday, February 28, 2017 1:58 PM
  • In the VB Editor, press F2


    peter n roth - http://PNR1.com, Maybe some useful stuff

    • Proposed as answer by Chenchen Li Wednesday, March 1, 2017 2:09 AM
    Tuesday, February 28, 2017 6:44 PM
  • There is Office 2013 VBA documentation available for download at https://www.microsoft.com/en-us/download/details.aspx?id=40326
    • Proposed as answer by Chenchen Li Wednesday, March 1, 2017 2:09 AM
    • Marked as answer by le_kai Friday, March 3, 2017 7:27 AM
    Tuesday, February 28, 2017 9:27 PM
  • This is perfect! Thanks for the reply, exactly what I was looking for -- a printable version of the documentation. Thanks to everyone else for the other great resources! 
    Friday, March 3, 2017 7:28 AM