Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Display image in Excel comment (Read 1972 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Display image in Excel comment
30.03.10 at 16:28:18
 
Display image in Excel comment
 
It is possible to display images in Excel comments. The following code will show you how to do this.  
 
Public Sub test()
    Dim cmt As Comment
     
    m_cmt("sheet1!A1").Shape.Fill.UserPicture "c:\fancy.gif"
    m_cmt("sheet1!A2").Shape.Fill.UserPicture "http://ogres-crypt.com/php/chart.php?d=12,3,44"
End Sub
 
Private Function m_cmt(Addr As String) As Comment
    On Error Resume Next
    Range(Addr).Comment.Delete
    On Error GoTo 0
    Set m_cmt = Range(Addr).AddComment
End Function
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1