User Posts: Rifat Hassan
0
Excel VBA: Develop and Use a Yes No Message Box
0

In this article, I’ll show you how you can develop and use a Yes No message box in VBA in Excel. Develop and Use a Yes No Message Box with Excel VBA ...

0
Excel VBA: Insert Timestamp When a Macro Is Run
0

In this article, I’ll show you how you can keep a timestamp in Excel VBA every time a Macro is run. Excel VBA: Insert Timestamp When a Macro Is Run ...

0
Excel VBA: Convert Formula to Value Automatically (2 Easy Methods)
0

In this article, I’ll show you how you can convert a formula of a worksheet to its value automatically using Excel VBA. Excel VBA: Convert Formula to ...

0
Excel VBA: Calculate Age from Date of Birth
0

In this article, I’ll show you how you can calculate age from the date of birth using VBA in Excel. VBA Code to Calculate Age from Date of Birth (Quick ...

0
Excel VBA: Wait Until a Process Complete
0

This article will show you how you can make your code wait until a process completes in Excel VBA. Excel VBA: Wait Until a Process Completes (Quick ...

0
How to Edit a Macro Button in Excel (5 Easy Methods)
0

In this article, I’ll show you how you can edit a Macro button on your worksheet in Excel. Download Practice Workbook Download this practice workbook ...

0
[Solve:] Cannot Edit a Macro on a Hidden Workbook (2 Easy Solutions)
0

Those who are to work with Excel VBA very often face this problem sometimes, we try but cannot edit a Macro and it’s shown that you cannot edit a Macro on a ...

0
Excel VBA: Select All Cells with Data
0

This article will show you how you can select all the cells that contain data within a worksheet using Excel VBA. Excel VBA: Select All the Cells with ...

0
How to Create Data Entry Form in Excel VBA (with Easy Steps)
0

While working with VBA in Excel, most of us face problems while trying to create a data entry form. In this article, I’ll show you how you can create a data ...

0
How to Save a Macro for All Workbooks in Excel (with Easy Steps)
0

While working with VBA in Excel, sometimes we need to save a Macro for all our workbooks. In this article, I’ll show you how you accomplish this pretty simply ...

0
Excel VBA: Choose Location and Save as PDF
0

In this article, I’ll show you how you can choose a location and save your workbook as a PDF using VBA in Excel. Excel VBA: Choose a Location and Save ...

0
Excel VBA: Turn Off Screen Update
0

It’s an important issue for all of us while working with VBA in Excel, to turn off the screen update. In this article, I’ll show you how you can turn off the ...

0
Excel VBA: Check If a Sheet Exists (2 Simple Methods)
0

One of the many things that we can accomplish using VBA in Excel is that we can check if a particular sheet exists in a workbook or not. In this article, I’ll ...

0
How to Write to a Text File Using Excel VBA
0

In this article, I’ll show you how you can write to a text file using VBA in Excel. How to Write to a Text File Using Excel VBA (Quick View) Sub ...

0
How to Save a Worksheet as a New File Using Excel VBA
0

One of many great uses of Excel VBA in our day-to-day life is that we can use it to save a worksheet as a new Excel file by running just a few lines of code. ...

Browsing All Comments By: Rifat Hassan
  1. Hi Tim, thank you for your valuable response. You can declare the variables this way:

    Dim File_Dialog as FileDialog
    Set File_Dialog = Application.FileDialog(msoFileDialogFolderPicker)

    Dim Sheet_Names(2) as Variant
    Sheet_Names(0)=”Sheet1″
    Sheet_Names(1)=”Sheet2″
    Sheet_Names(2)=”Sheet3″

    Dim New_File(2) as Variant
    New_File(0)=”New_Sheet1″
    New_File(1)=”New_Sheet2″
    New_File(2)=”New_Sheet3″

    But declaring variables beforehand is not mandatory in VBA. You can directly assign values to them as mentioned in the given codes.

  2. Hi Nico,
    Thanks for your response. You can use the FILTER function of Excel for your problem. Check this article for details https://www.exceldemy.com/excel-filter-multiple-criteria/.

  3. Hi Veronika, if your problem isn’t solved yet, you can send the file to my mail or can send an image of your file. I’ll try.

  4. Hi Arjun, the codes are absolutely flawless and there is no reason for them to not work properly. Did you insert the inputs correctly?

  5. Hi Luis,
    Thank you for your response. Hope this comes in handy for more people like you.

  6. Hello Sam,
    Thank you Sam for your response. It’s working fine now. Thank you again.

  7. Hi Mohammed, Thanks for your response. Insert the name of the text and the color code in the 2nd and 3rd lines of the codes directly.

  8. Hi Man, Thanks in advance. Can you please tell me where exactly the bug is? I have run the code in every way possible and there evolves no error. I think you couldn’t enter the inputs properly. Please go through the article again and then try. If it still doesn’t work, please tell me what exactly the error is.

  9. Hi Dennis,

    Thanks for your response. To skip the table name, first, remove the 4th line of the code, that is, Table_Name = InputBox(“Enter the Name of the Table: “).

    Then enter the name of the table within the 6th line of the code. For example, if the name of your table is “Table1”, then the line should be: Set tbl = ws.ListObjects(“Table1”).

    So the complete code will be:

    Sub Add_Empty_Row()

    Dim ws As Worksheet
    Set ws = ActiveSheet

    Dim tbl As ListObject
    Set tbl = ws.ListObjects(“Table1”)

    tbl.ListRows.Add

    End Sub

  10. I think the problem lies in the apostrophes. Use this code instead of yours. It works fine for me.

    Sub InsertRowsfromUserInput()
    Dim iRow As Long
    Dim iCount As Long
    Dim i As Long
    iCount = InputBox(Prompt:=”How Many Rows to Insert?”)
    iRow = InputBox _
    (Prompt:=”Where to Insert New Rows? (Enter the Row Number)”)
    For i = 1 To iCount
    Rows(iRow).EntireRow.Insert
    Next i
    End Sub

    If it still doesn’t work, after pasting the code in the VBA editor, change the apostrophes of the 5th and 7th lines manually. Hope it will work then.

  11. Thank you Ana. It’s difficult to give any suggestions without having a glance at the workbook. Would you please kindly share your workbook with me?

ExcelDemy
Logo