You are using an outdated browser. Please upgrade your browser to improve your experience.
VBA Guide For Excel

"VBA Guide For Excel really delivers very useful and simplified content for those who do not know this programming language, making you increasingly more efficient at using Microsoft Excel

Learn basic and key functions of Excel Visual Basic for Applications with this supremely helpful reference app

VBA Guide For Excel

by michael webb
VBA Guide For Excel
VBA Guide For Excel
$1.99 in the App Store

Learn basic and key functions of Excel Visual Basic for Applications with this supremely helpful reference app.

What is it about?

"VBA Guide For Excel really delivers very useful and simplified content for those who do not know this programming language, making you increasingly more efficient at using Microsoft Excel. If you are a regular user of this software, I would highly recommend downloading this app on your iPhone or iPad for easy reference."

For those who...

  • It’s perfect for anyone who wants to become more efficient when using Excel.

Not for those who...

  • If you don’t have a clue how to utilize Excel’s most basic features or have never once considered programming, you might want to start somewhere else. Although this app introduces you to the basics, you still need at least a small amount of experience with both Excel and VBA.

Why we love it

If you utilize Excel on a daily basis, check out the handy VBA Guide For Excel. It introduces you to basic and key functions of Excel VBA without becoming too complicated.

App Screenshots

VBA Guide For Excel screenshot-0
VBA Guide For Excel screenshot-1
VBA Guide For Excel screenshot-2
VBA Guide For Excel screenshot-3
VBA Guide For Excel screenshot-4

App Details

Version
3.3
Rating
(64)
Size
18Mb
Genre
Reference Books
Last updated
November 7, 2014
Release date
May 14, 2013
More info

App Store Description

"VBA Guide For Excel really delivers very useful and simplified content for those who do not know this programming language, making you increasingly more efficient at using Microsoft Excel. If you are a regular user of this software, I would highly recommend downloading this app on your iPhone or iPad for easy reference."
- AppPicker.com

VBA Guide For Excel explains some of the basic and key functions of Microsoft Excel VBA and also contains handy sample Excel macro's for whenever you may need them when building projects in Excel.

There are several Excel macro's in this app that show you how to send an email, how to find the last modified file in a folder and many more.

The macro examples pages have images which can be shown by swiping the text to the right.

Example macro's can be exported via:
- Email in message body
- Email with .txt attachment
- Exported as .txt file to other compatible apps on your device.
- SMS
- Print (via AirPrint)
- Copy the code to the device's clipboard.

Guide Page:
> Cell Navigation
> Sheets & Workbooks
> Variables
> If Statement
> Select Case Statement
> Error Handling
> Loops
> Worksheet Functions
> Functions
> References
> Offset Function
> Message Box
> Delay & Wait
> Single Dimension Array
> Date and Time
> VBA Editor Tips
> Debugging
> Events
> Collections
> Screen Updating
> SendKeys
> OnTime Function
> Subroutines

Example Pages: All with export options
> AutoFilter - Copy
> AutoFilter - Delete
> Clear Pivot Table Cache
> Count Files In Folder
> Download Files
> Email - Advanced
> Email - Basic
> Email - Sheet
> Email - Range to HTML
> File Properties
> Find Last Modified File
> Last row or column
> Lookup
> Loop through Files In Folder
> Create and/or Open Folder In Explorer
> Open (and interact with) Internet Explorer
> Open (and add data to) MS Word
> Get PC or Windows Username
> Replace Characters
> Screenshot (save as an image)
> Read and Write .txt files
> Zip Folder - Add Files
> Zip Folder - Extract Files
> Database - Create
> Database - New Record
> Database - Find Record
> Database - Update Record
> Database - Delete Record
> Get Email info from Outlook
> Open Any File
> Files and Folders - Copy
> Files and Folders - Move
> Files and Folders - Delete
> Shell Commands

Universal app compatible with iPhone and iPad.

On Facebook, like the 'VBA Guide for Excel' page for the latest news and updates.

Please leave a review. All feedback is welcome and can be sent from within the app.