Pictures Shapes Graphics

Blog Archives

Tom’s Tutorials For Excel: Linking a Drawing Object to a Cell

by Tom Urtis 2 Comments ↓

Tom’s Tutorials For Excel: Linking a Drawing Object to a Cell

Here’s how you can link a cell’s value to be displayed inside a drawing object. In this example, a Text Box is being used, but this method will also work for Rectangles and other draw-able Forms shapes.

…

Tom’s Tutorials For Excel: Programming Multiple Drawing Shapes

by Tom Urtis 8 Comments ↓

Tom’s Tutorials For Excel: Programming Multiple Drawing Shapes

Here’s how you can assign one macro to multiple drawing shapes on your worksheet, and have them all behave uniquely, depending on which shape was clicked.

In the pictured example, four Oval drawing shapes were placed on the worksheet,

…

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Data Science, Excel Expert, Excel Guru, Macros Events Classes API, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Pictures Shapes Graphics, Tom Urtis

Tom’s Tutorials For Excel: Inserting a Picture at a Specific Cell on Multiple Worksheets

by Tom Urtis 3 Comments ↓

Tom’s Tutorials For Excel: Inserting a Picture at a Specific Cell on Multiple Worksheets

Suppose you have a workbook, with several worksheets that often require your company logo to be inserted at a particular cell’s location. Assuming…
• You want the picture at the top left corner of cell D3.

…

Tom’s Tutorials for Excel: Putting a picture in a comment

by Tom Urtis 1 Comment ↓

Tom’s Tutorials for Excel: Putting a picture in a comment

Show comment.
Select comment and right click its edge.
Select Format Comment Colors and Lines tab.
Click drop-down arrow of Color field in Fill section.
Select Fill Effects Picture tab.
Click Select Picture button,

…