iTunes

Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator
Opening the iBooks Store.If iBooks doesn't open, click the iBooks app in your Dock.Progress Indicator
iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To buy and download VBA Guide For Excel by michael webb, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

I Have iTunes Free Download
iTunes for Mac + PC

VBA Guide For Excel

By michael webb

Open iTunes to buy and download apps.

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.

What's New in Version 3.3

> New guide -> OnTime
> New guide -> Subroutines

> New example -> Last Row or Column

> Added support for iPhone 6 and iPhone 6 Plus.

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

If you're enjoying the app please leave (or update) a review.

If you have any suggestions or if there are any features you would like to see in future updates please email me using the link within the app.

Screenshots

iPhone Screenshot 1
iPhone Screenshot 2
iPhone Screenshot 3
iPhone Screenshot 4
iPhone Screenshot 5
iPad Screenshot 1
iPad Screenshot 2
iPad Screenshot 3
iPad Screenshot 4
iPad Screenshot 5

Customer Reviews

Not a bad way to go

I started writing in VBA about a year ago and actually got picked to be a full time VBA coder about 4 months ago.
This app is informative for the beginner and easily laid out. Not overwhelming with information, but hits all the basic structures (loops, with-end with, declaring variables/functions, select case, if-then-else, etc.) great little pocket app for quick reference when you are just starting out or waiting for a bus.
Not as helpful once you get some experience under your belt and are looking to go to the next level (no REGEX, Dictionary, or ADODB - stuff I've used more recently). Still, great app if you are new to VBA or coding generally.

Some cool modules

Changed my rating when I discovered the more advanced examples that can be very useful. A cool feature to add would be a comments section for vba programmers to discuss the relevant modules.

I recommend to my Excel VBA Class

Very helpful reference for beginning Excel VBA programmers and the more advanced examples are great for those with a little experience.

VBA Guide For Excel
View in iTunes
This app is designed for both iPhone and iPad
  • $0.99
  • Category: Reference
  • Updated:
  • Version: 3.3
  • Size: 18.9 MB
  • Language: English
  • Seller:

Compatibility: Requires iOS 6.0 or later. Compatible with iPhone, iPad, and iPod touch.

Customer Ratings

Current Version:
All Versions: