VBA Guide For Excel 4+

michael webb

Designed for iPad

    • £1.99

Screenshots

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 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.

What’s New

Version 5.0

- Rebuilt from the ground up in Swift and with a new design.
- Supports dark mode (iOS 13.0+).
- All images in the guide pages are from the latest version of Excel.

Ratings and Reviews

4.1 out of 5
18 Ratings

18 Ratings

IBetThisOneIsTakenTo ,

Perfect Lookup For VBA Users

I have frequently used VBA for a few years now and although I consider myself to understand VBA to a great level, I feel that the information held in this app is invaluable for a reference guide - outstanding effort!

Ach_ ,

Super useful :)

I'm a beginner with VBA but even I can keep up with most of this and I know with more practice this app will just become more useful than ever - thanks!

BlueBaiano ,

Very useful!

This app provides plenty of helpful information and worked examples. It's a handy reference for anyone creating macros in Excel.

App Privacy

The developer, michael webb, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.

Data Not Collected

The developer does not collect any data from this app.

Privacy practices may vary based on, for example, the features you use or your age. Learn More

Supports

  • Family Sharing

    Up to six family members can use this app with Family Sharing enabled.

More By This Developer

Lineup - Football Squad
Sports
Easy Mortgage Calculator
Finance
Pool Shot Timer
Sports
Star Stacker
Photo & Video

You Might Also Like

German Verb Blitz
Education
French Verb Blitz
Education
Italian Verb Blitz
Education
GFI EDU
Education
Swahili Verb Blitz
Education
Practice Linear Equations
Education