If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould

You can download files here www.wiseowl.co.uk/videos/excelvba/application-inputbox.htm

www.wiseowl.co.uk - If you've used the generic InputBox function in VBA you may be frustrated by its limitations. This video shows you how to use the far superior Application.InputBox method. You'll learn how to specify the data type returned by the InputBox and how to use its built-in validation feature to control what users can enter. The video also covers how to return a simple formula and a more complex function from the InputBox and also how to allow users to select a range of cells which can then be referenced by your VBA code. The final part of the video covers a more complex example in which the InputBox returns an array of values which can be looped over and manipulated in various ways.

1. Getting Started in the VB Editor
2. Writing Your First VBA Macro
3. What to do When Things Go Wrong (Errors and Debugging)
4. Buttons, Toolbars and Keyboard Shortcuts
5. Selecting Cells (Range, Cells, Activecell, End, Offset)
6. Worksheets, Charts and Sheets
7. Workbooks
8. Variables
9. Object Variables
10. Message Boxes
11. Input Boxes
12. Application.InputBox
13. With Statements
14. If Statements
15. Select Case Statements
16. Do Until and Do While Loops
17. Find and FindNext
18. For Next Loops
19. For Each Loops
20. Creating Functions
21. Error Handling (On Error, Resume, GoTo)
22. Event Procedures
23. Application Events
24. User Forms
25. Files and Folders (FileSystemObjects)
26. Text Files (FileSystemObjects)
27. File Dialogs
28. Arrays
29. Constants and Enumerations (Const, Enum)
30. Creating Word Documents
31. Creating and Updating Linked Word Tables
32. Creating PowerPoint Presentations
33. Creating Outlook Emails
34. ADO (ActiveX Data Objects) Querying a Database
35. ADO (ActiveX Data Objects) Modifying Data with Recordsets
36. ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)
37. Creating Add Ins
38. Type Declarations (UserDefined Types)
39. Class Modules
40. Using Class Modules in Other Projects
41. Custom Collections
42. Typed Collections
43. Dictionaries
44. Disabling Screen Updates
45. Saving as a PDF
46. Data Labels in Scatter Charts
47. ByRef and ByVal
48. ByRef and ByVal (When to use Parentheses)
49. Making Excel Talk
50. Finding the Last Used Row, Column and Cell
51. Querying Web Pages using Query Tables
52. Browsing to Websites and Scraping a Web Page
53. Web Scraping Across Multiple Pages
54. Downloading Files from Websites
55. Introduction to Charts in VBA
56. Embedding Charts in Worksheets
57. Introduction to Pivot Tables in VBA
58. Pivot Tables using an Access Database
59. Pivot Tables using a SQL Server Database
60. Pivot Tables and Consolidation Ranges
61. PowerPivot Data Models
62. Pivot Charts
63. Pivot Table Slicers
64. Pivot Table Date Fields and Timelines
65. Introduction to Shapes
66. Formatting Shapes
67. Adding Text to Shapes
68. Working with Strings
69. Splitting Strings
70. The Join Function and Concatenating Strings
71. Replacing Strings
72. Converting the Case of Text
73. The Asc and Chr Functions
74. The IIf Function
75. The Switch Function
76. Working with Dates

Excel VBA is a powerful (and fun!) tool which allows you to automate your Excel workbooks. These videos will help you through your first steps on the way to becoming a programmer in Excel. You don't need any prior programming knowledge as we'll take things from first principles and hopefully give you a flavour of the cool things you can do with a little bit of effort!