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

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

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

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

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

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

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

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

0
Using Excel Data Validation in Date Format – 4 Examples

This is an overview.   This is the sample dataset.   Example 1 - Creating a Dynamic Drop Down List of Dates In the ...

0
How to Calculate Alpha in Excel: 4 Suitable Methods

Method 1 - Calculate Cronbach’s Alpha in Excel Steps: Go to Data >> Data Analysis >> Anova: Two Factor Without Replication and click on OK. ...

0
How to Create Cost of Delay Calculator in Excel (with Easy Steps)

Business analysts frequently have to choose which goods or projects to prioritize. There is a trade-off between projects, particularly about which project one ...

0
How to Use Excel VBA VLookup Within Loop (3 Examples)

    Overview of VBA VLookup So, what is VLookup? VLookup is a function in Excel that allows you to search for a value in a dataset ...

0
How to Ignore Blank Cells in a Named Range in Excel – 5 Methods

This will be the final output: The dataset showcases “Buying Price” and “Selling Price”. There are blank cells in "Selling Price”. To find the “Buy - ...

0
How to Create a Radial Bar Chart in Excel – 4 Steps

This is an overview: Step 1 - Preparing the Dataset The sample dataset showcases sales data of the “iPhone 14 Plus” in December 2022 in outlets ...

0
How to Prepare IF Statement Contains Multiple Words in Excel: 4 Methods

Method 1 - Use of Nested IF Function to Check Multiple Conditions Steps:   Use the IF function in the column to get the desired output. Type the ...

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