send link to app

VBA Guide For Excel app for iPhone and iPad


4.6 ( 5136 ratings )
Reference Book
Developer: michael webb
1.99 USD
Current version: 5.0, last update: 4 years ago
First release : 14 May 2013
App size: 15.71 Mb

"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 macros for whenever you may need them when building projects in Excel.

There are several Excel macros 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 macros can be exported via the iOS share sheet.

Guide Pages:
> 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.

Pros and cons of VBA Guide For Excel app for iPhone and iPad

VBA Guide For Excel app good for

Very good app! Didnt give 5 stars just because the guide should be in beginner to advanced order (as the free version), not in alphabetical order.
I refer to this app often as I am a beginner and learning. It is helpful to see the explanations.
This app is helping me improving my VBA skills. It has many examples and so easy to understand for beginners. I recommend buying it.
Very helpful reference for beginning Excel VBA programmers and the more advanced examples are great for those with a little experience.
Handy down-to-earth summary of VBA tips for a beginner like myself
Thanks for this small app with some usefull VBA tips. Lets try some of the macro examples tomorrow at work ! More examples such as clearing missingitems in pivot tables please :)

Some bad moments

Limited information and the search feature is basically worthless.
Ok for beginners in VBA. A lot of to do yet, but I havent met something familiar in store. Useful remainder and startup in excel programming.
The app has about 15 really useful guides and sample macros in there. One of them alone just helped my problem and will save me so much time, and worth a lot more than $1 for that alone!!! Highly recommend for anyone interested in getting started with Excel VBA
Good app for some basic and practical concepts to VB in Excel. The app layout, color scheme, animated demo (Gif), ... are great!
Great reference app. Needed this years ago. Takes a lot of the guesswork out of coding. Very handy. I could use an app like this for WORD if available. Thanks!
This has all the little coding stuff I have forgotten over time and it looks like it will be a useful reference in the future.

Usually VBA Guide For Excel iOS app used & searched for

excell, excel app, excel tutorial, learn excel, excel tutorial hd pro, and other. So, download free VBA Guide For Excel .ipa to run this nice iOS application on iPhone and iPad.