how to get count of comment inside cell

It is very simple, you just save the Excel workbook as an addin file (type xlam).

You then need to install it,

Click the Orange Office Button

Select Excel Options at the bottom

Select Addins from the left dialog pane

In 'Manage Excel Addins' click the Go button

Click the Browse button and navigate to your addin to install it


When you start Excel each time from now on, the addin is automatically loaded, and the workbook is hidden from view.

You can try this and see, i asked the same question which i asked you, to one of my friend, please let me know if you could figure out what exactly is this.

Q: how to bring the same formula to more than 50 files, do i need to type the VB script to all these 50 files or is there any way to call this function if i save it in one file.? what can i do.?

Record a macro and choose Personal Macro Workbook. Stop recording and copy the Function into a module in your personal file that Excel will have created for you. Use as shown below.


=PERSONAL.XLSB!Countcomments(A2:C2)
OR
=PERSONAL.XLS!Countcomments(A2:C2)

Regards

Ren

Is that a question or just your idea on the addin matter?

no its not a question to you, i asked the same question to one of my friend, he answered to that question, thats it. :) 

its an idea, my friend suggested to have the same function for 50 different excel files.

Thanks

Renjith

HI Bob,

Its an idea, if you want to call the same function (eg. CountComments) to more than one files.

1. open an excel

2. Record a macro.

3. select personal macro workbook from the list, give ok

4. then press alt F11, in your personal macro workbook, just type your code there. save it.

5. then try =PERSONAL.XLSB!CountComments(A2:C2)

The advantage is you dont have to keep typing the same code in every different excel file.

Please let me know if you have any doubts.

Thanks

Ren