Скачать с ютуб Wise Owl Answers - How do I draw a line in a cell in Excel VBA? в хорошем качестве

Wise Owl Answers - How do I draw a line in a cell in Excel VBA?

By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:    / @wiseowltutorials   Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! This video shows how to use VBA to draw lines on an Excel worksheet and position them relative to cells. You'll learn how to set the X and Y co-ordinates of the line start and end, and how to reference the Left, Top, Width and Height properties of a cell to control the position of the line. Chapters 00:00 The Question 00:34 Drawing a Line 02:59 Positioning a Line Relative to a Cell 04:37 Deleting all Shapes on a Worksheet 05:20 Drawing a Horizontal Line Halfway Down a Cell 06:32 Drawing a Line Across Multiple Cells 07:21 Changing How a Line Moves and Resizes 09:18 Drawing Multiple Lines at Intervals in a Cell 12:34 Adding Horizontal Lines 14:11 Dividing a Cell with Multiple Diagonal Lines 17:05 A Final Example Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!