Registration: Jan 5, 2023

Comments: 2

Total submitted: 27

Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology. In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his favorite pastimes.

Designation

Video Content Creator at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Biomedical Engineering (BME), BUET.

Expertise

Content Writing, VBA, C, C++, Python, Matlab, HTML, AutoCAD, CFD, Microsoft Office.

Experience

Technical Content Writing
Video Content Creating
Undergraduate Projects
- Haptic Based Dental Simulator
- CFD Analysis of Tracheobronchial Airway

Summary

Currently working as a Video Content Creator of ExcelDemy.
Started technical content writing of Excel & VBA in January 2023, moved to the Video Content Creator Team in July 2023.

Latest Posts From Hadi Ul Bashar

Page Break in Excel (Insert, Move, Remove and Fix)

In this article, we are going to learn everything about Excel page break. We’ll focus on how to insert page breaks manually as well as based on conditions. ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Create and Customize a Gantt Chart in Excel

What Is a Gantt Chart? A Gantt Chart is a visual representation of tasks over time, allowing us to track progress and manage project timelines. Dataset ...

Hadi Ul Bashar Jul 14, 2024

READ MORE +

Bell Curve in Excel (Plot and Format)

The Bell curve provides a quick visualization of a dataset summary. We can get a dataset's mean, mode, and median using the Bell curve of a normal ...

Hadi Ul Bashar Jul 18, 2024

READ MORE +

Guite To Excel Metadata: View, Modify and Remove

How to View Excel Metadata Method 1 - Using Info Option Select File. Go to Info. We will get metadata. Method 2 - Using ...

Hadi Ul Bashar Jul 7, 2024

READ MORE +

Excel Reconciliation Formula (for Data, Vendor, Bank)

In this article, we will demonstrate how to use the VLOOKUP, INDEX, MATCH and SUMIF functions to perform data reconciliation in Excel. Download ...

Hadi Ul Bashar Jun 25, 2024

READ MORE +

How to Export Excel Data to PowerPoint (3 Ways)

In this article, you will learn the methods of linking an Excel file to a PowerPoint. By doing so, we can present our Excel data in a PowerPoint slide. ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

Export Excel to PDF (4 Ways)

In this article, we will learn how to export an Excel file to a PDF. This conversion is helpful if you want to share your Excel data in a non-editable manner. ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

Name Box in Excel (All You Need to Know)

In this article, we will learn about the Name Box in Excel. We will focus on naming different kinds of elements, displaying the names in the Name Box, and many ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

Data Entry in Excel (Basic, Form Creation & Error Handling)

In this article, we are going to learn about data entry in Excel. We will learn about the basics of data entry, form creation, and error handling. Data ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

Excel VBA to Concatenate Cell Values

While working on Excel, sometimes we need to concatenate cell values. We can use Excel VBA to concatenate cell values easily. For example, if we have a dataset ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

How to Interact with a Target Cell Using Excel VBA (9 Examples)

Understanding the Target Cell Property When you want to interact with a cell in a worksheet using an event, you can utilize the Target property of Excel. ...

Hadi Ul Bashar Jul 24, 2024

READ MORE +

Excel VBA to Find Cell Address Based on Value (3 Examples)

The sample dataset contains the sales data of a certain showroom. Example 1 - Finding Only First Cell Address Based on Value By default, ...

Hadi Ul Bashar Jul 7, 2024

READ MORE +

Create InputBox with Multiple Inputs With VBA UserForm in Excel: 8 Step-by-Step Methods

Method 1 - Insert User Form to Create InputBox with Multiple Inputs in Excel The Visual Basic window will open. We’ll insert an UserForm from the Insert ...

Hadi Ul Bashar May 22, 2024

READ MORE +

Excel VBA Multidimensional Arrays

If you’re thinking about storing multiple data against a common entry, a multidimensional array can serve the need. Multidimensional Arrays are arrays with ...

Hadi Ul Bashar Nov 11, 2025

READ MORE +

Excel MIN Function Returns 0: 2 Possible Scenarios

We're going to cover the cases where the Excel MIN function returns 0, as well as some workarounds to deal with this. Here's an overview of the dataset we'll ...

Hadi Ul Bashar Jul 22, 2024

READ MORE +

Browsing All Comments By: Hadi Ul Bashar

Hadi Ul Bashar Jul 9, 2023 at 12:52 PM

Hello VIKASHINI,

Thank you for explaining your issue in a concise way. Yes, it is possible to extract the whole sentence. You can apply the following steps for that:

1. First of all, open your Word document.
2. Go to Developer tab and select Visual Basic.
3. Navigate to Insert tab and select Module.
4. Type the following code in the module and press the F5 key to run the macro.

Sub ExtractCommentsAndSentencesToExcel()
    Dim xApp As Excel.Application
    Set xApp = CreateObject("Excel.Application")
    xApp.Visible = True

    Dim xWB As Excel.Workbook
    Set xWB = xApp.Workbooks.Add

    Dim xWS As Excel.Worksheet
    Set xWS = xWB.Worksheets(1)
    xWS.Range("A1:B1").Value = Array("Sentence", "Comment")
    
    Dim rowNum As Integer
    rowNum = 2

    Dim doc As Document
    Set doc = ActiveDocument
    
    Dim cmnt As comment
    For Each cmnt In doc.Comments
        Dim sentenceText As String
        sentenceText = cmnt.Scope.Sentences(1).text
        
        xWS.Cells(rowNum, 1).Value = sentenceText
        xWS.Cells(rowNum, 2).Value = cmnt.Range.text
        
        rowNum = rowNum + 1
    Next cmnt
    
    xWS.Columns("A:B").AutoFit
    
    Set xWS = Nothing
    Set xWB = Nothing
    Set xApp = Nothing
End Sub

Check the following images that contain the sample output.

This is the output you will get in an Excel file.

Please let me know if you have any further issues.
Have a good day!
Regards,
Bashar
Exceldemy.

Reply
Hadi Ul Bashar May 11, 2023 at 10:36 AM

Hello DEEP!

From your comment, I think the most possible reason of the error could be inappropriate cell referencing. Please note that these formulas include both absolute and relative cell reference. You may copy paste the formulas, and then adjust the cell references according to your dataset. Hopefully that will solve your issue.

Output:

If you need further assistance regarding this, please feel free to send the Excel file in this email [email protected].

Regards
Hadi Ul Bashar