Image control embeds a picture such as a jpg, jpeg, gif, png, bitmap, etc. It can be used on the WorkSheet. You can see how it works and more details about ActiveX Image Control on the Worksheet in the following chapter.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


VBA ActiveX Image Control on the Worksheet

Please find more details about VBA ActiveX Image Control on the Worksheet.

  1. Go To Developer Tab and then click Insert from the Controls
  2. Click on the Image_control from the ActiveX Controls group.
  3. Drag the control on the Worksheet.
  4. Right click on the Image_control, before that Design Mode should be turned ON.
  5. Click on properties from the available list.
  6. On the left side find ‘Picture’ from the available properties of the control.
  7. On the right side click on that, and select image from the source.
  8. On the left side find ‘PictureSizeMode’ from the available properties of the control.
  9. On the right side, select ‘1 – frmPictureSiseModeStretch’ from the available list.
  10. Now, you can see the following output as shown below in the screen shot.

Delete Image Control on the Worksheet using VBA

Please find the below code, it will show you how to delete or remove the control on the worksheet. In the below example, its deleting the Image named ‘Image1’ which is on the worksheet named ‘Sheet11’. Where Delete is the property of Shape object.

Sub Delete_Image()
Sheets("Sheet11").Shapes("Image1").Delete
End Sub
LIMITED TIME OFFER

Leave A Comment


Related pages


excel formula hideexcel vba booleanvba runsqlunload userformrisk dashboard template excelremove duplicates in excel columnsql coding interview questionshow to convert an excel file to xmlexcel programingmacro to unprotect worksheetexcel 2007 vba macro programmingexcel combine data from multiple sheets into one sheetwhat is adodbproject tracking excel spreadsheetfso filestring to int vbasubstitute vba excelexcell concatenatejob costing template freeshot keys of exceluserform command buttonmulti select listboxenter vbavba copy sheet to new workbookvba file objectaccess msgboxnested if function excel 2010 exampleconditional vlookupaverageifs examplevba delete duplicatesexcel macro applicationmessagebox usingproject management excel gantt chart templatedata definition language commandsunprotect excel 2010 workbookdelete both duplicates in exceladvanced excel vbamacro delete blank rowsnew adodb.connectionvbe excelexcel vba countvba excel tutorialssql recordsetms office gantt chart templateadodb connection vba referenceinterview questions asked in genpact for financehiding cells in excelvba worksheetfunctioncells vba exceldebug vbaclear formatting excelhow to create a drop down menu in excel 2007excel convert to lower casedashboard creation toolscopy worksheet to another worksheetsample project timeline excelclose excel in vbaexcel xml exampledeleting cells in excelvba read filevba count worksheetspull data from another workbookunprotect macro excellookup formula in excel 2007excel line chart templatespassword protect an excel workbookfunctions in vba excelsimple excel gantt chart templatemessagebox syntaxhow to use vlookup functioncombine data from multiple worksheets