VBA

Visual Basic for Applications (commonly abbreviated VBA) is an offset of Visual Basic which is used for automating Microsoft products, particularly the Office suite.

Resources

• Excel Decision Matrix: http://www.timeatlas.com/5_minute_tips/general/using_excel_in_decisions
• VBScript: https://docs.microsoft.com/en-us/previous-versions/t0aew7h6(v=vs.85)

Tutorials

• How to create an "alert" in a SharePoint 2013 site: http://support.sherweb.com/Faqs/Show/how-to-create-an-alert-in-a-sharepoint-2013-site
• Check grammar, spelling, and more in Word: https://support.microsoft.com/en-us/office/check-grammar-spelling-and-more-in-word-0f43bf32-ccde-40c5-b16a-c6a282c0d251
• Middle align text vertically in table cell in Word 2010+ : https://answers.microsoft.com/en-us/msoffice/forum/all/middle-align-text-vertically-in-table-cell-in-word/71677ecf-aeb5-4c69-9ec1-14b8816ba53d
• How to extract email addresses from a excel sheet: http://www.get-digital-help.com/2009/01/30/how-to-extract-email-addresses-from-a-excel-sheet/
• Extracting An Email Address From Text: http://spreadsheetpage.com/index.php/tip/extracting_an_email_address_from_text/
• Extract Multiple Emails from a single cell: http://groups.4google.com/group/microsoft.public.excel.misc/browse_thread/thread/77262cb5c118c1ac/a1474eb589b22d7b?lnk=gst&q=extract+email#a1474eb589b22d7b
• Excel Macro -- Email Address Extract from String: http://www.yogeshguptaonline.com/2009/11/excel-macro-email-address-extract-from.html
• VBA Substring – How to Substring in Excel Macro: http://www.exceltrick.com/formulas_macros/vba-substring-function/
• Finding matching values using excel vba: https://stackoverflow.com/questions/18795974/finding-matching-values-using-excel-vba#18796775
• VBA code to show Message Box popup if the formula in the target cell exceeds a certain value: https://stackoverflow.com/questions/10013285/vba-code-to-show-message-box-popup-if-the-formula-in-the-target-cell-exceeds-a-c (MsgBox "Your message here")
• Compare two string variables ignoring case: https://stackoverflow.com/questions/19098977/compare-two-string-variables-ignoring-case
• Excel, VBA, and REST URLs - A Sample Application: http://developer.webtrends.com/community/dx/blog/2009/08/26/excel-vba-and-rest-urls--a-sample-application
• Excel -- Get Underlying Hyperlink Address: http://www.ozgrid.com/VBA/HyperlinkAddress.htm
• How to loop through a list of data on a worksheet by using VBA macros in Excel: https://support.microsoft.com/en-us/kb/299036
• Converting a Decimal Number to hh:mm:ss Format in Excel: http://support.microsoft.com/kb/214122 (display fraction of hours as minutes, i.e. 4.13 ==> 4 hr 8 min)
• Convert Text in Cells to Lowercase: http://www.teachexcel.com/free-excel-macros/m-30,text-to-lowercase.html
• Get the current cell in Excel VB: http://stackoverflow.com/questions/2202093/get-the-current-cell-in-excel-vb
• Excel Vlookup function: https://www.excelhow.net/excel-vlookup-function.html
• How to Look up Value and Return Adjacent Cell Value in Excel: https://www.excelhow.net/how-to-look-up-value-and-return-adjacent-cell-value-in-excel.html

• Excel Pivot Tables Tutorial - What is a Pivot Table and How to Make one: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
• Intro to Power Pivot: http://chandoo.org/wp/2013/01/21/introduction-to-power-pivot/
• 6 Tips for Making Microsoft Excel Charts That Stand Out: https://www.howtogeek.com/774446/tips-for-making-microsoft-excel-charts-that-stand-out/
• Create an asset tracker solution using InfoPath & Excel: https://support.office.com/en-us/article/Create-an-asset-tracker-solution-using-InfoPath-and-Excel-DF1F6AF2-442C-41E1-B2E1-AACE45BF7CFD

• Excel's COUNTBLANK function: http://spreadsheets.about.com/od/countfunctions/qt/2010-04-12-excel-2010-count-blank-function.htm
• Print a worksheet to fit a paper width or a number of pages: http://office.microsoft.com/en-ca/excel-help/print-a-worksheet-to-fit-a-paper-width-or-a-number-of-pages-HP005201821.aspx
• Apply auto-fit property to multiple columns simultaneously: http://www.techrepublic.com/blog/msoffice/apply-auto-fit-property-to-multiple-columns-simultaneously/3892
• Excel Tip -- Auto-Fit Multiple Columns: http://tpltechnology.blogspot.ca/2008/08/excel-tip-auto-fit-columns.html
• Quick start -- Apply conditional formatting: http://support.office.com/en-us/article/Quick-start-Apply-conditional-formatting-6B6F7C2A-5D62-45A1-8F67-584A76776D67
• Excel -- change column headers from letters to numbers: http://answers.yahoo.com/question/index?qid=20061106095341AAKpbFJ
• How Can I Save a Single Excel Worksheet to a CSV File?: http://blogs.technet.com/b/heyscriptingguy/archive/2005/03/22/how-can-i-save-a-single-excel-worksheet-to-a-csv-file.aspx
• How to Make Sortable Headings in Excel: http://smallbusiness.chron.com/make-sortable-headings-excel-29977.html
• Add common prefix to all cells in Excel: http://stackoverflow.com/questions/2703431/add-common-prefix-to-all-cells-in-excel
• How to add/insert prefix or suffix to range of cells in Excel?: https://www.extendoffice.com/documents/excel/784-excel-add-prefix-suffix-cells-columns-rows.html
• Capitalize words and sentences EASILY: http://word-tips-world.blogspot.ca/2007/03/capitalize-words-and-sentences-easily.html
• How to Freeze or Lock ROWS and COLUMNS: http://support.office.com/en-nz/article/Freeze-or-lock-rows-and-columns-3439cfe6-010c-4d2d-a3c9-d0e8ba62d724
• Sum/Count Cells By Fill Or Background Color in Excel: http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
• How to count and sum cells based on background color in Excel?: http://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html
• Count how often a value occurs: https://support.office.com/en-us/article/count-how-often-a-value-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd
• Count the number of cells with a specific cell color using VBA: https://docs.microsoft.com/en-us/office/troubleshoot/office-developer/count-cells-number-with-color-using-vba
• Split text into different cells in Excel: http://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7
• Using Excel's Find and Mid to extract a substring when you don't know the start point: https://www.techrepublic.com/article/using-excels-find-and-mid-to-extract-a-substring-when-you-dont-know-the-start-point/
• How to get tick marks in Excel? [custom cell formatting]: http://chandoo.org/wp/2009/09/15/get-tick-marks-in-excel/
• How do I count Y (yes) and N (no) in a column: http://www.mrexcel.com/forum/excel-questions/33579-how-do-i-count-y-yes-n-no-column.html
• Filter for unique values or remove duplicate values: https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
• How to Calculate CAGR in Microsoft Excel: https://www.howtogeek.com/806670/cagr-formula-excel/

• Show all tasks that are marked complete in Outlook 2013: https://support.office.com/en-nz/article/Show-all-tasks-that-are-marked-complete-1b411fe4-f45b-4559-816f-e5a9bee87ba0#__toc251758233 (##In Tasks, on the View tab, in the Current View group, click Change View and then click "Completed" or "Detailed List")
• Extract embedded slides from a Word document: http://skp.mvps.org/pptxp010.htm
• Get external data from a Web page (MS Office 2007+ official): https://support.office.com/en-us/article/Get-external-data-from-a-Web-page-708F2249-9569-4FF9-A8A4-7EE5F1B1CFBA
• Different Ways of Using Web Queries in Microsoft Office Excel 2003: https://msdn.microsoft.com/en-us/library/aa203721%28v=office.11%29.aspx?f=255&MSPPError=-2147217396
• Pull data into Microsoft Excel with Web queries: http://www.techrepublic.com/article/pull-data-into-microsoft-excel-with-web-queries/
• Extract URL data to Excel: http://stackoverflow.com/questions/6442395/extract-url-data-to-excel
• Extract Data from Website to Excel VBA: http://officetricks.com/extract-data-from-website-to-excel-vba/
• Import or export text (.txt or .csv) files: https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba
• How to Convert JSON to Excel: https://allthings.how/how-to-convert-json-to-excel/ (import within Excel via "Data" tab --> "Get Data" --> "From File" --> "JSON" then follow steps to import desired columns)
• Read/Parse text file line by line in VBA: http://stackoverflow.com/questions/11528694/read-parse-text-file-line-by-line-in-vba
• Open a Text File in Excel VBA: http://homeandlearn.org/open_a_text_file_in_vba.html
• Transpose (rotate) data from rows to columns or vice versa: https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419F2E3-BEAB-4318-AAE5-D0F862209744
• Excel - Switch (transpose) columns and rows http://office.microsoft.com/en-us/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx
• Rotate data by converting columns to rows (or vice versa): http://office.microsoft.com/en-ca/excel-help/rotate-data-by-converting-columns-to-rows-or-vice-versa-HP005203138.aspx
• Load CSV file into a VBA array rather than Excel Sheet: http://stackoverflow.com/questions/12259595/load-csv-file-into-a-vba-array-rather-than-excel-sheet
• opening csv files using macro: https://social.msdn.microsoft.com/Forums/office/en-US/d8ecc4f3-712d-4002-b7bd-b93f2c2bcd9f/opening-csv-files-using-macro
• Create or delete a PivotTable or PivotChart report (EXCEL): https://support.office.com/en-us/article/Create-or-delete-a-PivotTable-or-PivotChart-report-d09e4d07-8cd6-4b60-afad-8fb67418800f
• Copy Data to Another Worksheet with Advanced Filter: http://excelsemipro.com/2011/03/copy-data-to-another-worksheet-with-advanced-filter/
• Excel - Printing a Workbook Double-Sided: http://www.softwarepro.com/howto/excel_print_workbook_duplex.htm
• How to Read or Update an Excel File from another Excel File: http://officetricks.com/different-methods-to-import-data-from-external-excel-file/
• How to extract a unique distinct list from a column in excel: http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/
• How to use the ISNUMBER Function: http://www.techonthenet.com/excel/formulas/isnumber.php
• How to Add Input Restrictions to Validate Data in Excel: https://www.laptopmag.com/articles/add-input-restrictions-validate-data-excel
• How to Create a Drop Down List in Excel: http://www.wikihow.com/Create-a-Drop-Down-List-in-Excel
• If I have a spreadsheet with a large number of URLs in one column, how can I generate a list of unique domains that appear?: https://www.quora.com/If-I-have-a-spreadsheet-with-a-large-number-of-URLs-in-one-column-how-can-I-generate-a-list-of-unique-domains-that-appear
• Excel If Cell Contains Text: https://excelx.com/formula/if-cell-contains-text/
• Count cells that do not contain: https://exceljet.net/formula/count-cells-that-do-not-contain
• Format cell if cell contains date less than today: https://stackoverflow.com/questions/27059799/format-cell-if-cell-contains-date-less-than-today
• Calculate number of days between a DATE & TODAY: http://www.excelforum.com/excel-formulas-and-functions/543570-calculate-number-of-days-between-a-date-and-today.html
• Convert date/time value to a date value (remove time portion): https://www.techonthenet.com/excel/questions/remove_time.php
• Remove seconds in the date-time number in Excel: https://stackoverflow.com/questions/30403411/remove-seconds-in-the-date-time-number-in-excel
• How to extract milliseconds from time in Excel?: https://www.extendoffice.com/documents/excel/3245-excel-extract-milliseconds-from-time.html
• How do I get rid of milliseconds from a whole column of data in Excel?: http://www.makeuseof.com/answers/rid-milliseconds-column-data-excel/
• How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?: https://superuser.com/questions/678934/how-can-i-get-the-displayed-value-of-a-cell-in-ms-excel-for-text-that-was-conv
• How to parse XML using VBA: http://stackoverflow.com/questions/11305/how-to-parse-xml-using-vba
• Build your Excel skills with these 10 power tips: http://b2b.cbsimg.net/downloads/Gilbert/TR_promo_excel.pdf
• InputBox Function: http://www.excel-easy.com/vba/examples/inputbox-function.html
• VBA Split Function – How to Use: http://www.exceltrick.com/formulas_macros/vba-split-function/
• Assigning value to cells with Excel VBA: https://codereview.stackexchange.com/questions/59382/assigning-value-to-cells-with-excel-vba
• Excel VBA -- function to turn activecell to bold: https://stackoverflow.com/questions/6045826/excel-vba-function-to-turn-activecell-to-bold
• VBA convert string to int if string is a number: https://stackoverflow.com/questions/6202074/vba-convert-string-to-int-if-string-is-a-number#6202469
• Excel REPLACE/REPLACEB Function: https://www.thoughtco.com/replace-add-characters-to-data-excel-3123666
• MS Excel -- How to concatenate strings together (WS, VBA): https://www.techonthenet.com/excel/formulas/concat2.php
• How to Merge Two Columns Without Losing Data in Excel: https://www.exceltip.com/tips/how-to-merge-two-columns-without-losing-data-in-excel.html
• Excel Fill Down: https://www.wallstreetmojo.com/excel-fill-down/ (double-click on the bottom-right corner of a cell to "select down" to the last adjacent non-empty row, then use shortcut CTRL+D to fill with the same formula downwards, changing the cell count by one each time)
• How to Enable Excel Macros: https://www.techwalla.com/articles/how-to-enable-excel-macros
• Shortcut to Open Macro dialog box: https://exceljet.net/keyboard-shortcuts/open-macro-dialog-box (ALT+F8)
• Run a macro via a Shortcut key: https://support.office.com/en-us/article/run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155 (needs to be set per Excel file... commonly CTR+m is available/recommended)
• How to identify uppercase, lowercases, and proper cases in Excel?: https://www.extendoffice.com/documents/excel/1055-excel-identify-case.html
• How do I detect any uppercase letter in an Excel cell?: https://superuser.com/questions/926020/how-do-i-detect-any-uppercase-letter-in-an-excel-cell (ANWSER: =NOT(EXACT(LOWER(A1),A1)))
• Change the case of text: https://support.office.com/en-us/article/Change-the-case-of-text-01481046-0fa7-4f3b-a693-496795a7a44d
• MS Excel 2013+ Display the Developer tab in the toolbar: https://www.techonthenet.com/excelcop/questions/developer_tab2013.php
• How To Create Stopwatch In Excel Worksheet?: https://www.extendoffice.com/documents/excel/3684-excel-create-stopwatch.html#a1
• MS Excel - How to use the ISEMPTY Function (VBA): https://www.techonthenet.com/excel/formulas/isempty.php
• Loop Until Column A is empty: https://www.ozgrid.com/forum/forum/help-forums/excel-general/95517-loop-until-column-a-is-empty
• Calculate the average of a group of numbers: https://support.office.com/en-us/article/calculate-the-average-of-a-group-of-numbers-e158ef61-421c-4839-8290-34d7b1e68283
• Convert YYYYMMDD raw text to actual Excel DATE format DD/MM/YYYY: https://www.excel-exercise.com/convert-date-yyyymmdd-to-dd-mm-yyyy-without-formula/
• How to convert between date and Unix timestamp in Excel?: https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html
• Automatically insert timestamps in excel sheet using formulas: https://chandoo.org/wp/timestamps-excel-formula-help/
• How to abbreviate numbers in Excel?: https://www.extendoffice.com/documents/excel/2228-excel-abbreviate-numbers.html
• Excel's Auto Outline quickly hides data details to simplify viewing: https://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/
• Grouping Rows in Excel: https://www.mcstech.net/grouping-rows-in-excel/
• How to resize row height or column width to fit text in Excel?: https://www.extendoffice.com/documents/excel/1665-excel-resize-row-column-to-fit-text.html
• How to Create a Stacked Bar Chart in Excel: https://www.smartsheet.com/stacked-bar-chart-graph
• How to Show Percentages in Stacked Bar and Column Charts: https://www.exceltactics.com/show-percentages-stacked-bar-column-charts/
• Fill Under or Between Series in an Excel XY Chart: https://peltiertech.com/fill-under-between-series-in-excel-chart/
• How to Add a Trendline in Microsoft Excel: https://www.howtogeek.com/798850/how-to-add-a-trendline-in-microsoft-excel/

• Microsoft opens up Excel to custom data types with images, arrays, and more: https://www.theverge.com/2021/11/2/22759149/microsoft-excel-javascript-api-custom-data-types-feature (Excel gets a new JavaScript API for developers)
• Reading Values From Excel in Java: https://www.baeldung.com/java-read-dates-excel

External Links

• More Custom Functions for Access and Excel: http://www.fontstuff.com/vba/vbatut05.htm
• Extract Email Data From Outlook Global Address List: http://www.vbaexpress.com/kb/getarticle.php?kb_id=222
• Excel VBA Basic Tutorial: http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
• Quick Excel Chart VBA Examples: http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html
• VBA Examples: http://word.tips.net/W012_VBA_Examples.html
• Excel VBA - FindAll Method: http://vbadud.blogspot.com/2007/10/excel-vba-findall-method.html
• Excel VBA Simulation Basic Tutorial: http://www.anthony-vba.kefra.com/vba/excelvba-simulation-102.htm
• Count Occurences in String: http://xl.barasch.com/ACo141623.htm
• Find occurences of a character in string: http://www.bigresource.com/Tracker/Track-vb-qLR7waWQr7/
• MS-Access Tutorials: http://www.brainbell.com/tutorials/ms-office/Access_2003/
• Running a Crystal Report in VBA: http://forums.esri.com/Thread.asp?c=93&f=992&t=67019&mc=9
• How to use Crystal report with MS-Access: http://www.vbcode.com/Asp/showsn.asp?theID=11540
• Microsoft Access - Reading records into Crystal Report for export as Excel?: http://database.itags.org/ms-access-database/155227/
• Importing Master Data from Microsoft Excel File to SAP: http://it.toolbox.com/blogs/sap-library/importing-master-data-from-microsoft-excel-file-9996
• VBA Examples: http://excel.tips.net/E206_VBA_Examples.html
• VBA for Excel (BOOK): http://www.scribd.com/doc/7471496/Vba-for-Excel-Made-Simple
• VBA for Excel (Macro lessons): http://www.excel-vba.com/excel-vba-contents.htm
• Geocode an Address using Excel and Geocoder.us: http://www.automateexcel.com/2005/07/16/geocode_an_address_using_excel_and_geoco/
• Canadian Google Maps In Excel: http://www.automateexcel.com/2005/09/24/canadian_google_maps_in_excel/
• Excel geocoding adventures: http://blog.jonudell.net/2007/08/10/excel-geocoding-adventures/
• Import Data Directly into Excel: http://www.brainbell.com/tutorials/ms-office/excel/Import_Data_Directly_Into_Excel.htm
• MSDN - Using the Excel 2003 Object Model to Add XML Data Integration: http://msdn.microsoft.com/en-us/library/aa203724(office.11).aspx
• Excel, REST, and XMLMAPS.Import vs WINHTTP: http://www.automateexcel.com/2005/03/17/excel_rest_and_winhttp_thoughts/
• November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in: http://blogs.office.com/2016/12/01/november-2016-updates-for-get-transform-in-excel-2016-and-the-power-query-add-in/
• Knowing Excel — Yes, Microsoft Excel — Is Crucial To Making More Money: http://www.huffingtonpost.com/entry/you-cant-escape-the-hegemony-of-the-spreadsheet_n_6816570.html
• Best Excel Charts Types for Data Analysis, Presentation and Reporting: https://www.optimizesmart.com/how-to-select-best-excel-charts-for-your-data-analysis-reporting/
• The 7 Biggest Excel Mistakes of All Time: https://www.teampay.co/insights/biggest-excel-mistakes-of-all-time/
• How to Insert an Image Inside of Text in Microsoft Word (or PowerPoint): https://www.howtogeek.com/707608/how-to-insert-an-image-inside-of-text-in-microsoft-word/

See Also

Visual Basic | VBscript | Microsoft