Monday, May 30, 2016

Customizing Context Menu For Adding Image Into Comment

           In previous tutorial, we've created a template that to add an image into comment with the button.In this template, we will add a image into cell's comment via right click (context) menu .

For this process, we've created a new context menu item.

When  the mouse right-clicked on any sheet of workbook ; the macro that we created ,will open the dialog box to select image file .
The user selects a picture and opened input box asks for the percent of scaling to apply to display of the picture.


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.


Monday, May 23, 2016

Replace Data In A Closed Workbook (Ado)

Find And Replace Data In A Closed Workbook (Ado) Without Opening It

            If you want to replace data from a closed workbook ,you can do this process fairly quickly with ADO .
Before, you can choose the workbook that you want to modify. Then, any sheet of listed sheets in the drop-down box  is selected .



Monday, May 9, 2016

Find Repeating Data On The Sheet With Number Of Repetitions


        As sample, data in Column A was used in this macro.

When the button is pressed,data in "Column A" are listed  into "Column G" and "Column H" with the number of repetitions.

Tutorial's video :