Learn Excel – VBA Picture Comments: Podcast #1386
One of the old tricks in Microsoft Excel is adding a pop-up picture to a cell. I showed this a long time ago on an episode of TechTV. The VBA code that I used back in Excel 2003 to add the pop-up pictures is no longer working in Excel 2010. Today, with Episode #1386, Bill shows us how to update the code for use in Microsoft Excel 2010. You will find an example of the modified code below.
Sub AddPictureToComments1() ' Bill Jelen For Each cell In Range("F3:F5") cell.AddComment cell.Comment.Text Text:="" cell.Comment.Visible = True cell.Comment.Shape.Select Selection.ShapeRange.Fill.UserPicture "C:\aaa\" & cell.Value & ".jpg" cell.Select cell.Comment.Visible = False Next End Sub
…This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
For more Excel 2010 knowledge, check out “Excel 2010 In Depth“, by Bill Jelen a.k.a. MrExcel.
“The Learn Excel from MrExcel Podcast Series”
MrExcel.com — Your One Stop for Excel Tips and Solutions.
Entry filed under: Excel 2010, Excel 2010 In Depth, Learn Excel from MrExcel, MrExcel Products, VBA and Macros. Tags: 2010, accounting, business, Excel, Excel 2003, Excel 2010, Macro, MrExcel, Picture, Picture Comments, Pictures in Excel 2010, Pop-up, spreadsheets, technology, tutorial, VBA, Worksheet.