Introduction to Shapes 
Introduction to Shapes
by WiseOwl
Video Lecture 65 of 76
Not yet rated
Views: 283
Date Added: May 16, 2017

Lecture Description

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!

You can download the file created in this video from this page www.wiseowl.co.uk/videos/excelvba/intro-to-shapes.htm

By Andrew Gould

www.wiseowl.co.uk - In this video you'll learn the basic of working with shapes in VBA. You'll see how to reference objects in the shapes collection using a variety of techniques. You'll learn about the properties which determine a shape's size and position and how to set these relative to other objects. You'll also learn how to add a variety of shapes to a worksheet, including basic autoshapes, pictures and form control buttons, as well as how to attach an action to a shape so that it runs a macro when a user clicks it.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more

Course Index

  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

Course Description

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!

Comments

There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)