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


userform excel 2007vba check boxcombobox templatehow to remove blank lines in excelhow to do vlookup in excel 2010 step by stepclose file vbatask planner template exceldelete duplicates in column excelvba populate comboboxcan you unprotect an excel spreadsheetsave as filename vbaexcel color duplicatesvba array excelvba excel dynamic arrayhow to use vlookup in excel 2003 step by stepvba codes for accessmacro worksheetmacros databasedefined names in excelpivot table in excel 2010 with exampledo while loop excel vbaexcel macro format cellexcel option button valuesql macrosql data mining tutorialsoftware development cost estimation templatesales analysis template excelwhat is ddl and dmlhow to prepare pivot table in excel 2010monthly meeting minutes templatetimeline templates for excelfso deletedynamic chart titlehow to connect excel to sql serverhow do i unprotect an excel worksheetdelete rows in excel using vbavba stopvbcrlf vbaproject timetable template excelexcel based dashboardhow to put a title on excel graphhow do you identify duplicates in excelhow to use concatenate function in excel 2010merging cells on excelexcel using macrosexcel macro sort rangeexcel table remove duplicatesworking with arrays in excelhow to unhide sheets in excelexcel formula from another sheetmultiple if and statements in excelhow to write macro in excelunderstanding vlookupexcel findbvba getrowsexcel macro open filespecial characters in excel formulasuserform command buttonvba workbook closeapplication.filedialogsql statements in excelautofilter excel 2013vba excel open filemicrosoft excel multiple if statementswriting sql queries in excelvba close userformhow to unhide column in excelexcel vba fileformathow use vlookup in excel 2010excel vba sortingworksheet functions in vbavba code tutorialresource allocation template excel freemacro recorder excel 2010vba excel select casehow to delete blank cells in excel 2010listbox additem vbavba boxinsert row in excel shortcutexcel isnumberactiveworkbook saveas