VBA Guide For Excel

Name: VBA Guide For Excel
Price: 1.99 USD
Rating: 3.7 (51 reviews)
Author: michael webb

參考

US$1.99 · 專為 iPad 設計

51則評分
年齡

4+
歲
類別

參考
開發者

michael webb
語言

EN
英文
大小

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

評分與評論

3.7

(滿分 5 顆星)

51則評分

Not a bad way to go
2015/04/25

wackojacko1997
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.
Not a bad way to go
2015/04/25

wackojacko1997

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.
Not bad for beginners
2017/09/24

ApertureXTC
The app has limited information on Excel VBA. While this may be good reference for someone starting off, lack of explanation on subjects like multidimensional arrays doesn’t even put it in the intermediate category. Most of this information can be found for free on the internet easily.
Not bad for beginners
2017/09/24

ApertureXTC

The app has limited information on Excel VBA. While this may be good reference for someone starting off, lack of explanation on subjects like multidimensional arrays doesn’t even put it in the intermediate category. Most of this information can be found for free on the internet easily.
Awesome app
2018/06/10

Scottscott123123
Great for beginners or intermediate coders. Nice to look through when you are thinking of a project or just killing some time. I taught myself strictly based off current project needs, so seeing the possibilities as well as what I already know, with plenty of clear well descriptive examples makes this app a must have for people who enjoy the capabilities of Vba.
Awesome app
2018/06/10

Scottscott123123

Great for beginners or intermediate coders. Nice to look through when you are thinking of a project or just killing some time. I taught myself strictly based off current project needs, so seeing the possibilities as well as what I already know, with plenty of clear well descriptive examples makes this app a must have for people who enjoy the capabilities of Vba.
Extremely useful asset
2020/01/22

irefusetoenteraname
Love this app, there’s a lot of value in it for people who are new to VBA but still requires a little know how to get you going. I wish I worked for a larger company so other people could appreciate how far I’ve come along.
Extremely useful asset
2020/01/22

irefusetoenteraname

Love this app, there’s a lot of value in it for people who are new to VBA but still requires a little know how to get you going. I wish I worked for a larger company so other people could appreciate how far I’ve come along.

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