Home › Reference
Information
Apple ID622398496
Bundle IDcom.Excelpanda.Excel-VBA
SellerSeller
Min iOS12.0
Min macOS11.0
Device familiesiphone, ipad, ipod
Released2013-05-14
Copyright© Excelpanda
Privacy policyLink ↗
Preview 2 platforms
iPhone 5 images
iPad 5 images
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.
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.
Accessibility
ipadiphonemacrealityDevicetvoswatch
Version history 13 versions
Build 834862153v5.02020-02-26 00:03:15
- 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.
Build 829201982v4.02018-11-07 17:01:36
- Updated to fit all iOS devices including the iPhone XS, iPhone XS Max, iPhone XR and all iPad models including the new iPad Pro.
- All sharing options now use the default share sheet.
- Send/Cancel buttons on share pages no longer show as white text.
- New icon.
- Added privacy policy.
- Bug fixes.
Build 725012642v3.32014-11-07 02:23:45
> 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.
Build 584553717v3.22014-05-12 02:33:25
Search Results:
> You can now search the Guide pages and Examples using the search bar at the top of each contents page.
Easier Export Options:
> Examples macros and your own notes can now be exported from the contents pages. Press and hold on the cell and the export options will appear without the page opening.
New Guide page:
> SendKeys
New Examples:
> Files and Folders - Copy
> Files and Folders - Move
> Files and Folders - Delete
> Shell Commands
If you have any more suggestions please email me from within the app.
If you're enjoying the app please leave a review/rating. They all help!
Build 514312631v3.12014-04-02 22:04:19
Guide pages:
> VBA code is now highlighted with a light grey background.
> VBA code is also indented where needed for easier reading.
If you have any more suggestions please email me from within the app.
If you're enjoying the app please leave a review/rating. They all help!
Build 486812637v3.02014-03-27 22:48:41
Nice big update!
New notes section:
> Now you can keep all your sample code and snippets in the app, all of which, have the same exporting options as the built in example macro's.
New Guide Pages:
> Events
> Collections
> Screen Updating
New Examples:
> Get Email info from Outlook
> Open Any File
> Google Maps API
Other Improvements:
> Guide and Example macros now sorted alphabetically
If you're enjoying the app please leave a review/rating. They all help!
If you have any suggestions or would like to see any new features please email me from within the app.
Build 302022639v2.32014-01-16 23:29:42
Updated UI
New Guide pages.
> Date and Time
> VBA Editor Tips
> Debugging
New Example Macros
> Zip Folder - Add Files
> Zip Folder - Extract Files
> Database - Create
> Database - New Record
> Database - Find Record
> Database - Update Record
> Database - Delete Record
Please leave a review or update your original review. All reviews are a massive help.
As always, all feedback is welcome and can be sent from within the app.
Build 116092664v2.22013-11-14 22:35:47
New Example - Open MS Word
New Guide - Single Dimension Arrays
*Bug fix for Guide section for iPhone 4/4S users.
Please leave a review or update your original review.
As always, all feedback is welcome and can be sent from within the app.
Build 87622648v2.12013-11-06 03:45:59
* Re-designed guide section. Now includes text formatting and animations for better guidance.
* New guide sections added.
- Message Boxes
- Wait & Delay
* New sample macros added.
- Download Files
- Email - Range to HTML Table
- Loop through files
- Read from & Write to .txt files.
* Improved sharing options.
Please leave a review or update your original review.
As always, all feedback is welcome and can be sent from within the app.
Build 54982802v2.02013-09-25 19:14:34
Updated for iOS7 - New clean look!
New export options.
- Example macros can now be emailed as a .txt file attachment.
- Example macros can be exported as a .txt file to other compatible apps on your device.
New example macro.
Screenshot - Shows you how to save a set range as a JPEG image within a folder.
Please leave a review or update your original review.
As always, all feedback is welcome and can be sent from within the app.
Build 15854422v1.22013-07-21 21:44:25
- Theme redesign for easier reading.
- Offset function guide.
- Interact with Internet Explorer example macro.
If you're enjoying this app please leave a review.
Thanks to Geoff Barnes and Mark Merrell for their input towards this update!
Build 15558936v1.12013-06-12 21:03:54
New Guide section added.
Build 14743927v1.02013-05-14 18:04:35
Price history by region
Currency
Show
Columns
Search
Availability 51 of 51 storefronts
| Region | Language | Price | Ratings | Avg | Version |
|---|---|---|---|---|---|
US | en-US | USD 1.99 | 51 | 3.7 | 5.0 |
CA | en-CA | CAD 2.99 | 5 | 4.8 | 5.0 |
RU | ru | RUB 199 | 3 | 5.0 | 5.0 |
DZ | en-GB | USD 1.99 | 1 | 5.0 | 5.0 |
IT | it | EUR 1.99 | 1 | 1.0 | 5.0 |
LU | en-GB | EUR 1.99 | 1 | 4.0 | 5.0 |
AG | en-GB | USD 1.99 | 0 | — | 5.0 |
AO | en-GB | USD 1.99 | 0 | — | 5.0 |
BB | en-GB | USD 1.99 | 0 | — | 5.0 |
BH | en-GB | USD 1.99 | 0 | — | 5.0 |
BS | en-GB | USD 1.99 | 0 | — | 5.0 |
BW | en-GB | USD 1.99 | 0 | — | 5.0 |
BZ | en-GB | USD 1.99 | 0 | — | 5.0 |
CG | en-GB | USD 1.99 | 0 | — | 5.0 |
CI | fr-FR | USD 1.99 | 0 | — | 5.0 |
CM | fr-FR | USD 1.99 | 0 | — | 5.0 |
CV | en-GB | USD 1.99 | 0 | — | 5.0 |
DM | en-GB | USD 1.99 | 0 | — | 5.0 |
DO | es-MX | USD 1.99 | 0 | — | 5.0 |
FJ | en-GB | USD 1.99 | 0 | — | 5.0 |
FM | en-GB | USD 1.99 | 0 | — | 5.0 |
GD | en-GB | USD 1.99 | 0 | — | 5.0 |
GY | en-GB | USD 1.99 | 0 | — | 5.0 |
HN | es-MX | USD 1.99 | 0 | — | 5.0 |
JM | en-GB | USD 1.99 | 0 | — | 5.0 |
JO | en-GB | USD 1.99 | 0 | — | 5.0 |
KN | en-GB | USD 1.99 | 0 | — | 5.0 |
KW | en-GB | USD 1.99 | 0 | — | 5.0 |
LT | en-GB | EUR 1.99 | 0 | — | 5.0 |
LV | en-GB | EUR 1.99 | 0 | — | 5.0 |
ML | en-GB | USD 1.99 | 0 | — | 5.0 |
MU | en-GB | USD 1.99 | 0 | — | 5.0 |
MV | en-GB | USD 1.99 | 0 | — | 5.0 |
MZ | en-GB | USD 1.99 | 0 | — | 5.0 |
NA | en-GB | USD 1.99 | 0 | — | 5.0 |
NI | es-MX | USD 1.99 | 0 | — | 5.0 |
OM | en-GB | USD 1.99 | 0 | — | 5.0 |
PG | en-GB | USD 1.99 | 0 | — | 5.0 |
QA | en-GB | QAR 7.99 | 0 | — | 5.0 |
SB | en-GB | USD 1.99 | 0 | — | 5.0 |
SN | en-GB | USD 1.99 | 0 | — | 5.0 |
SR | en-GB | USD 1.99 | 0 | — | 5.0 |
SV | es-MX | USD 1.99 | 0 | — | 5.0 |
TO | en-GB | USD 1.99 | 0 | — | 5.0 |
TT | en-GB | USD 1.99 | 0 | — | 5.0 |
UA | en-GB | USD 1.99 | 0 | — | 5.0 |
UG | en-GB | USD 1.99 | 0 | — | 5.0 |
VN | en-GB | VND 59000 | 0 | — | 5.0 |
VU | en-GB | USD 1.99 | 0 | — | 5.0 |
ZM | en-GB | USD 1.99 | 0 | — | 5.0 |
ZW | en-GB | USD 1.99 | 0 | — | 5.0 |
Change log 16 changes · ZW
✎
releaseNotes updated
- 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 Ex
✎
description updated
"VBA Guide For Excel really delivers very useful and simplified content for those who do not know this programming language, making you increasingly more effici
✎
name updated
VBA Guide For Excel
◆
Version 5.0 released
- 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.
◆
Version 4.0 released
- Updated to fit all iOS devices including the iPhone XS, iPhone XS Max, iPhone XR and all iPad models including the new iPad Pro.
- All sharing options now use the default share sheet.
- Send/Cancel buttons on share pages no longer show as
◆
Version 3.3 released
> 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 th
◆
Version 3.2 released
Search Results:
> You can now search the Guide pages and Examples using the search bar at the top of each contents page.
Easier Export Options:
> Examples macros and your own notes can now be exported from the contents pages. Press and h
◆
Version 3.1 released
Guide pages:
> VBA code is now highlighted with a light grey background.
> VBA code is also indented where needed for easier reading.
If you have any more suggestions please email me from within the app.
If you're enjoying the app pleas
◆
Version 3.0 released
Nice big update!
New notes section:
> Now you can keep all your sample code and snippets in the app, all of which, have the same exporting options as the built in example macro's.
New Guide Pages:
> Events
> Collections
> Screen Updat
◆
Version 2.3 released
Updated UI
New Guide pages.
> Date and Time
> VBA Editor Tips
> Debugging
New Example Macros
> Zip Folder - Add Files
> Zip Folder - Extract Files
> Database - Create
> Database - New Record
> Database - Find Record
> Database - Update Re
◆
Version 2.2 released
New Example - Open MS Word
New Guide - Single Dimension Arrays
*Bug fix for Guide section for iPhone 4/4S users.
Please leave a review or update your original review.
As always, all feedback is welcome and can be sent from within the app.
◆
Version 2.1 released
* Re-designed guide section. Now includes text formatting and animations for better guidance.
* New guide sections added.
- Message Boxes
- Wait & Delay
* New sample macros added.
- Download Files
- Email - Range to HTML Table
- Loop
◆
Version 2.0 released
Updated for iOS7 - New clean look!
New export options.
- Example macros can now be emailed as a .txt file attachment.
- Example macros can be exported as a .txt file to other compatible apps on your device.
New example macro.
Screenshot
◆
Version 1.2 released
- Theme redesign for easier reading.
- Offset function guide.
- Interact with Internet Explorer example macro.
If you're enjoying this app please leave a review.
Thanks to Geoff Barnes and Mark Merrell for their input towards this updat
◆
Version 1.1 released
New Guide section added.
◆
Version 1.0 released
USen-US
CAen-CA
RUru
DZen-GB
ITit
LUen-GB
AGen-GB
AOen-GB
BBen-GB
BHen-GB
BSen-GB
BWen-GB
BZen-GB
CGen-GB
CIfr-FR
CMfr-FR
CVen-GB
DMen-GB
DOes-MX
FJen-GB
FMen-GB
GDen-GB
GYen-GB
HNes-MX
JMen-GB
JOen-GB
KNen-GB
KWen-GB
LTen-GB
LVen-GB
MLen-GB
MUen-GB
MVen-GB
MZen-GB
NAen-GB
NIes-MX
OMen-GB
PGen-GB
QAen-GB
SBen-GB
SNen-GB
SRen-GB
SVes-MX
TOen-GB
TTen-GB
UAen-GB
UGen-GB
VNen-GB
VUen-GB
ZMen-GB