Missing VBA code for Excel [Format Comment]-[Colors and Lines]-[Fill Effects]-[Picture]-[Lock picture aspect ratio]

reinht 21

I can't find any Excel VBA code for:

With Cells(1, 1).Comment.Shape  
  .Fill.UserPicture "C:\Users\JohnDoe\Pictures\Picture.jpg"  
    
  '\How to set option [Format Comment]-[Colors and Lines]-[Fill Effects]-[Picture]-[Lock picture aspect ratio] in VBA?  
    
  '\Following line is not the same  
  .LockAspectRatio = msoTrue  
End With

Cells(1, 1).Comment.Shape..LockAspectRatio = msoTrue is not the same

Any ideas?

TIA
Reinhard

Viki Ji_MSFT 4,471 Reputation points

2021-08-23T01:15:14.75+00:00

Hi @reinht ,
Welcome to Q&A forum!
Since your issue is more related to Excel VBA code, I will remove the tag office-excel-itpro that focuses on general issue about Excel client.
Thanks for your understanding!

Share via

Missing VBA code for Excel [Format Comment]-[Colors and Lines]-[Fill Effects]-[Picture]-[Lock picture aspect ratio]

Your answer