Extract Comments in Excel Cells using formula
HTML-код
- Опубликовано: 23 июн 2019
- #UDF #VBA
Hello Friends,
In this video, you will learn how to create a user-defined function in VBA to get the comment text from an Excel Cell. Let’s say we have attendance data on the Excel sheet and We are putting comments for the absent employees. Now if we need to fetch these comments in Excel cell to do some analysis then we can use this UDF.
Click here to download the practice file:
www.pk-anexcelexpert.com/udf-...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
amzn.to/2PlFFFz
U defied precisely thanks 🙏
Thanks
Thank you so much👍👍👍👍👍
Most welcome
Great advice and thanks - Problem, this works for "Notes" not "Comments".
That's right
Hi, I copied the code as directed but I am getting #VALUE! errors even for cells where I have Comments. Tried running it with the code from your Practice File with same results. I can't get it to work so do you have any ideas what could cause this? Thank you
Thanks😻
Welcome
Hi, i am trying to freeze an illustration while moving to another cell it should be visible all the time when i move anywhere in the sheet. can you help me.
Hello .can you show me how to link comment cell to other cell ?
If we old comments clear and enter new comments and how will comments auto update in cell without re-enter formula?
Will create a video on this
Dear sir how to create monthly tution fees payment on Excel with automatic update months wise if he paid fees it will show paid else showing 1 or 2month Balance...
How do i save this to use it in future?
How to make this as searchable drop-down list insert coment
Pls make video for this
No that is not work without coding