Hadi Ul Bashar

About author

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

0
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. ...

0
Gantt Chart in Excel (Plot and Customize)

In this article, we will learn about the Gantt chart in Excel. This is not a built-in chart in Excel but we can create such a chart following some steps. You ...

0
Bell Curve in Excel (Plot and Format)

In this article, we will learn about the Bell curve in Excel. You will get the step-by-step procedure to draw a Bell curve with the necessary explanation here. ...

0
Excel Metadata (View, Modify and Remove)

In this article, we will learn about Excel metadata. We will learn how to view, modify, or remove all or selected metadata. We need to view the metadata to ...

0
Excel Reconciliation Formula (for Data, Vendor, Bank)

In this article, we will learn about the Excel reconciliation formula. To reconcile data, we will use the VLOOKUP, INDEX, MATCH and SUMIF functions. We do a ...

0
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. ...

0
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. ...

0
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 ...

0
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 ...

0
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 ...

0
Excel VBA Target Cell: 9 Practical Examples

Looking for ways to interact with a target cell using VBA in Excel? Then, this is the right place for you. If you want to interact with a cell in the ...

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

If you frequently use Excel, you may have encountered scenarios where you needed the address of a cell that contained a specific value. For instance, we may ...

0
Excel VBA: Create InputBox with Multiple Inputs

Looking for ways to create an inputbox with multiple inputs using VBA in Excel? Then, this is the right place for you. Excel VBA InputBox is a built-in ...

0
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 ...

1
Excel MIN Function Returns 0: 2 Possible Scenarios

You may use Excel’s MIN function to get the minimum value from a range of cells. In some cases your Excel MIN function returns 0. In this article, I’m going to ...

Browsing All Comments By: Hadi Ul Bashar
  1. 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.

  2. 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.

    solution of comment

    Output:

    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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo