Sunday, May 29, 2016

Using Vba To Add An Image Into Cell’s Comment

           When button in the sheet is clicked ,the macro  will open the dialog box to select image file , the user selects a picture, then an input box asks for the percent of scaling to apply to display of the picture. 

The picture will be inserted into the comment box of the currently selected cell. The picture will popup from the worksheet when the mouse hovers over the cell just as a normal comment would.