100+ VBA Interview Questions and Answers with Examples

Home/100+ VBA Interview Questions and Answers with Examples

VBA Interview Questions and Answers with Examples, macro codes – Download Free PDF File. Top Most 100+ commonly asked Basic and Advanced VBA Interview Questions and Answers Covered for Freshers and Experienced VBA Developers.Important ,Latest, Logical, Technical, Programming, Simple and Tough questions and answers from MS Excel VBA, Access VBA, PowerPoint VBA, MS Outlook and Word VBA Questions and Answers with tests and Quizzes.Top Most VBA Interview Questions & Answers with Examples

100+ VBA Interview Questions and Answers Explained with proper examples by topic. FAQs are useful for all Excel VBA users to refer Excel VBA quickly. Please find the below are more than 100 VBA FAQs:Frequently Asked Interview Questions and Answers explained with examples which we have experienced.

Basic VBA Interview Questions and Answers

Here are the most commonly asked Basic VBA Questions and Answers covered from Basics of VBA Programming.

  • VBA stands for Visual Basic for Applications.
  • VBA is Programming language available in MS Office Tools.
Data types helps to declare Variables with specific data, this helps to VBA to know the type of the data and assign the memory based on the DataType of the Variable.
  1. Boolean
  2. Byte
  3. Currency
  4. Date
  5. Double
  6. Integer
  7. Long
  8. LongLong
  9. LongPtr
  10. Object
  11. Single
  12. String
  13. Variant
Variant data type is default data type and it can hold any type of data. This will allocate maximum memory to hold the Varian Type. We use Variant data-type when we dot know the type of the data or to accept the multiple data types in a single variable.
We can define variable in different levels:

  • Local Level: Variables which are defined with DIM statement in a procedure or functions
  • Module Level: Which are defined with DIM statement on top of a module, can be accessed in entire module
  • Global Level: Which are defined Public statement at top of any module, can be accessed in entire project.

Read More Basic VBA Interview Questions and Answers

More Basic VBA Interview Questions

Advanced VBA Interview Questions and Answers

Here are the top most Advanced VBA Questions and Answers covered from Advanced concepts of VBA Programming.

Option Explicit force the variables to be declared befre using the variable. This is one of of the best practices for VBA developers to avoid the type errors and build the error free applications.
Code Module: Default Modules which we use to write all procedures and functions
UserForms: UserForms helps to develop GUI (Graphical User Interface) applications.
Class Modules: Class module allows to create new objecs and define methods, properties and events. Also, it will allow to enhance the existing objects.
Procedures or Subroutines will not return a value; functions will return values.
Arguments can be passed in two ways in VBA Subroutines and Functions:
ByVal: When an argument is passed By Value, the value assigned to the argument is passed to the procedure. And any changes that are made to the argument inside a procedure, it will be lost when the procedure is ends.

ByRef: When an argument is passed By Ref, the actual address assigned to the argument is passed to the procedure. And any changes that are made to the argument inside the procedure will be passed when the procedure ends.
And By Ref is default in VBA.

Workbook, Worksheet modules are Class modules.

Read More Advanced VBA Interview Questions and Answers

More Advanced VBA Interview Questions

Top Most Excel VBA Interview Questions and Answers

We have covered most frequently asked Excel VBA Interview Questions and Answers, divided into different sections. Take your own time to understand the questions and answers. Please ask us if you have any further questions.
Please let us know your interview experience and share your experience. Please let us know if you want to add any questions, which we have missed here.

Please find the below basic Object model of Excel.
Application –> Workbooks –> Worksheets –> Range / Chart
A macro is nothing but set of instructions which are stored in Visual Basic module in a VBA Editor. It helps in automating common repetitive tasks on daily, weekly or monthly basis by running macro. Using macros, you can save lot of time, increase productivity and on time delivery to customers.
You can use the ‘Alt+F11’ key to go to VBA editor screen
Please find the following steps to stop recording macro in the workbook.
Step 1: Go To Developer tab from the main ribbon of Excel window.
Step 2: Click on ‘Stop Recording’ command button to stop from the recording macro.
Please find the following steps to delete macros from the workbook.
Step 1: Go To Developer tab from the main ribbon of Excel window.
Step 2: Click on the Macros command button to see the available macros in the active workbook.
Step 3: Once you click on the Macros command button, Macro dialog box will appear on the screen.
Step 4: Select macro name which you want to delete macro and then click on ‘Delete’ command button.
Step 5: Now, It will show the confirmation dialog box. Click on Ok to delete the macro.
This is one of the most commonly asked Excel VBA Interview Questions and Answers. You can use Workbook_Open() Event to run macros automatically in Excel VBA while opening Workbook.

To get Workbook_Open() Event in Excel, please find the following steps.
1. Go To VBA Editor.
2. Click on ‘ThisWorkbook’ from the Project Explorer.
3. Now, you can see two drop down lists in the right side.
4. Select ‘Workbook’ from the first drop down list and then choose ‘Open’ from the second drop down list.
5. Now, you can see the following code.

Private Sub Workbook_Open()
‘Your Statements…..
End Sub

6. You can add the code in-between the above lines to run a macro.
7. Save and close the workbook
8. Now, reopen the workbook to test the macro.
Example:

Private Sub Workbook_Open()
MsgBox "Workbook has Opened Successfully.”, vbInformation
End Sub

In the above example, the macro will run automatically when we are opening workbook. Now, it will display message like “Workbook has Opened Successfully.”.

Or we can also define a procedure named Auto_Open() in any code module, this will execute while opening the macro file.

You can use Workbook_Open() Event to show UserForm automatically in Excel VBA when we open Workbook.

To get Workbook_Open() Event in Excel, please find the following steps.
1. Go To VBA Editior.
2. Click on ‘ThisWorkbook’ from the Project Explorer.
3. Now, you can see two drop down lists in the right side of the VBA Editor window.
4. Select ‘Workbook’ from the first drop down list and then choose ‘Open’ from the second drop down list.
5. Now, you can see the following code.

Private Sub Workbook_Open()
‘Your Statements…..
End Sub

6. You can add the code in-between the above lines to run a macro.
7. Save and close the workbook
8. Now, reopen the workbook to test the macro.
Example:

Private Sub Workbook_Open()
‘ Here "MyForm” is the UserForm name.
MyForm.Show
End Sub

In the above example, the macro will show the UserForm(Named ‘MyForm’) automatically when we open Workbook.
Note: Before running above macro add UserForm and then assign the name of the UserForm to ‘MyForm’.

ByVal vs ByRef in VBA is also one of the most frequently asked Excel VBA Interview Questions and Answers.
ByVal:
Specifies that an argument is passed in such a way that the called procedure or property cannot change the value of a variable underlying the argument in the calling code.
ByRef:
Specifies that an argument is passed in such a way that the called procedure can change the value of a variable underlying the argument in the calling code.
Note: Default value is ByRef. It is good practice to include the ByRef declaration if you are going to change the value of the parameter.
Please find the different looping statements which are available in Excel VBA.
For…. Next loop, Do While…. Loop, Do until Loop, Do….Loop Until..,Do While Not…Loop, While…. Wend loop
Please find the following steps to add UserForm or Module or Class Module to the VBA Project.
Add UserForm:
Step 1: Go To Insert menu in the VBA Editor window.
Step 2: Click on ‘UserForm to add to the Project. Now you can see added UserForm in the Project Explorer. Default UserForm name will be ‘UserForm1’. You can change the UserForm name with using properties

Add Module:
Step 1: Go To Insert menu in the VBA Editor window.
Step 2: Click on ‘Module’ to add to the Project. Now you can see added Module in the Project Explorer. Default module name will be ‘Module1’. You can change the module name with using properties.

Add Class Module:
Step 1: Go To Insert menu in the VBA Editor window.
Step 2: Click on ‘Class Module’ to add to the Project. Now you can see added Class Module in the Project Explorer. Default Class module name will be ‘Class1’. You can change the class module name with using properties.

We can create object variable and it can use in entire procedure. Please find the following examples to create object for workbook, worksheet, etc.
Create object for Workbook:

Sub Create_Object_Workbook()
Dim Wb As Workbook
Set Wb = ActiveWorkbook
MsgBox Wb.Sheets(1).Name
End Sub

Explanation: In the above example, I have created and assigned to Active Workbook to ‘Wb’ objet. And then I have used it in the next statement(MsgBox Wb.Sheets(1).Name) to display first worksheet name.

An array is a set of variables that are similar type. Using an array, you can refer to a specific value of an array by using array name and the index number (also called subscript).

We can create and define size of an array variable in the following way.
Dim ArrayName (IndexNumber) As Datatype
Example: Dim aValue(2) As Integer
In the above statement ‘aValue’ is an array name and ‘2’ indicates an array size.

We can assign values to an array in the following way.
‘Declare an array variable
Dim aValue (2) As Integer
aValue(0)=”first”
aValue(1)= “Second”
aValue(2)= “Third”
‘Or
Dim aValue () As Integer={” first “,”Second”,”Third”}
Data Type: A data type tells, what kind of variable we are going to use in a procedure or function. The information that specifies how much space a variable needs called a data type.
Before using variable, we need to know how much space the variable will occupy in memory, because different variables occupy different amount of space in memory.

We can declare the variable in the following way.
Dim VariableName as Datatype

Example:
Dim iCnt as Integer

Where iCnt represents VariableName and Integer represents Datatype.

The following are different data types which are available in Excel VBA.
Byte, Boolean, Integer, Long, Single, Double, Currency, Decimal, Date, Object, String, Variant and User defined data types.
For more information please find the following link.

Read More …

UserForm Controls:
Button, Combo Box, Check Box, Spin Button, List Box, Option Button, Group Box, Label, Scroll Bar, etc,.
ActiveX Controls:
Command Button, Combo Box, Check Box, List Box, Text Box, Scroll Bar, Spin Button, Option Button, Label, Image, Toggle Button.
Please find the following steps to assign macro to a button.
Step 1: Go to the Developer tab from the excel ribbon menu, go to Forms Control group.
Step 2: Click on Button from the Form Controls.
Step 3: Click the worksheet location where you want the button to appear.
Step 4: Drag the button in the sheet.
Step 5: Right click on the button, click on Assign Macro.
Step 6: Assign Macro Dialog box will appear now, click the name of the macro that you want to assign to the button. Click on OK.
Step 7: You can format the control by specifying control properties.
Step 8: Click on button to test. Now, your macro should run.
Understanding the scope of variables is very important for VBA Developers, it is also one of the most frequently asked Excel VBA Interview Questions and Answers.

When we are working with variables, it is important to understand the Scope of a Variable. The Scope describes the accessibility or life time or visibility of a variable.
There are four levels of Scope:
• Procedure-Level Scope
• Module-Level Scope
• Project-Level Scope
• Global-Level Scope
For more information please find the following link.

Read More …

We need to find Last used Row with data if we want to perform certain task on each row of worksheet. Please find the following statements to find last row in the worksheet.

Find last row in the worksheet:

Dim lastRow As Long
lastRow = ActiveSheet.Cells.SpecialCells(xlLastCell).Row
For more information please find the following link.

Read More …

We need to find Last used Column with data if we want to perform certain task on each column in the worksheet. Please find the following statements to find last column in the worksheet.

Find last column in the worksheet:

Dim lastColumn As Long
lastColumn = ActiveSheet.Cells.SpecialCells(xlLastCell).Column
For more information please find the following link.

Read More …

We have several best practices to follow while coding VBA. This is also one of the most frequently asked Excel VBA Interview Questions and Answers. This helps interviewer to understand your real time experience in VBA.
We can fasten the execution of macros or VBA Procedures by following the below tips.
1. Declare the variables and avoid using ‘Variant’ Data Type.
2. Turn Off Screen Updating
3. Turn Off Automatic Calculations
4. Disable Events
5. Use With Statement
6. Use vbNullString instead of “”.
7. Release memory objects at the end of the procedure.
Enabling and Disabling the Screen updating will be used in almost all projects. Questions on understanding the screen updating are also one of the most frequently asked Excel VBA Interview Questions and Answers.
Here is the approach to enable or disable screen updating or screen flickering.
In order to stop the screen flickering, stop the screen updating at Staring of the procedure:

Application.ScreenUpdating = False

You have to set back screen updating as True Before ending of the procedure:

Application.ScreenUpdating = True

Here is the approach to stop trigger or display alerts or error warnings.
In order to stop triggers, disable the display alerts at Staring of the procedure:

Application.DisplayAlerts = False

You have to set enable display alerts before ending of the procedure:

Application.DisplayAlerts = True

Please find the below different types of error handling techniques.
1. On Error Resume Next
2. On Error Goto Err_Lbl
3. On Error Goto 0

You can find a specific file exist or not in the following two ways.
1. Using FileSystemObject:
Here is the example to check file exist or not using ‘FileSystemObject’.

Sub Check_File2()
Dim FSO
Dim sFileName As String
sFileName = "C:/Test/Workbook.xls"    
Set FSO = CreateObject("Scripting.FileSystemObject")
If Not FSO.FileExists(sFileName) Then
MsgBox "File Does Not Exists."
Else
MsgBox "File Exists."
End If
End Sub

2. Using Dir Function:
Here is the example to check file exist or not using ‘Dir’ function.

Sub Check_File1()
Dim sFileName As String
sFileName = "C:/Test/Workbook.xls"
If Dir(sFileName) <> "" Then
MsgBox "File Exists."
Else
MsgBox "File Does Not Exists."
End If
End Sub

For more information please find the following link.

Read More …

You can save the workbook using following example. In the below example we are adding new workbook and then assigned it to object named Wkb. Finally we are saving workbook with using Save method of workbook object.

Sub Save_Workbook()
Dim Wkb As Workbook
Set Wkb = Workbooks.Add
Wkb.Save    
End Sub

Please find the following link for more information on saving workbook using Excel VBA.

Read More …

You can change the existing file name of workbook using the following example. In the below example we are adding new workbook and then assigned it to object named Wkb. Finally we are changing workbook name with using SaveAs method of workbook object.

Sub SaveAs_Workbook()
Dim Wkb As Workbook
Set Wkb = Workbooks.Add
ActiveWorkbook.SaveAs Filename:="C:\Test.xlsm"    
End Sub

Please find the following link for more information on changeing the existing file name.

Read More …

Please find the following statements to delete a file from the specified location.

Sub sbDelete_File()
Dim FSO
Dim sFile As String
sFile = "C:\Test.xlsm"
'Set Object
Set FSO = CreateObject("Scripting.FileSystemObject")
'Check File Exists or Not
If FSO.FileExists(sFile) Then
FSO.DeleteFile sFile, True
MsgBox "Deleted The File Successfully", vbInformation, "Done!"
Else
MsgBox "Specified File Not Found", vbInformation, "Not Found!"
End If
End Sub 

Note: Before deleting file from the specified location, we have to check whether file is exists or not in the specified location. In the above example we are using statement:’ FSO.FileExists(sFile)’ to check for the file.
Please find the following link for more information on deleting a file in a specified location.

Read More …

You can copy a file from one location to another location in the following way.

Sub Copy_File()
Dim FSO
Dim sFileName As String
Dim dFileName As String    
sFileName = "D:\Test.xlsx"  'Source File Location Name
dFileName = "E:\Test.xlsx"  'Destination File Location Name    
Set FSO = CreateObject("Scripting.FileSystemObject")
FSO.CopyFile sFileName, sFileName, True    
End Sub

Please find the following link for more information on copying a file from one location to another location.

Read More …

You can move a file from one location to another location in the following way.

Sub Move_File()    
Dim sFileName As String
Dim dFileName As String    
sFileName = "D:\Test.xlsx"  'Source File Location Name
dFileName = "E:\Test.xlsx"  'Destination File Location Name    
Name sFileName As sFileName
End Sub

Read More MS Excel VBA Interview Questions and Answers

55+ MS Excel VBA Interview Questions and Answers with Examples

MS Access VBA Interview Questions and Answers with Examples

Here are the most commonly asked MS Access VBA Questions and Answers covered from Basics of VBA Programming.

Here is the following VBA procedure to create table in the required database using VBA.

'Create table in the required database using VBA
Sub sbCreate_Table()
Dim DBase As Database
'
'Open Databse
Set DBase = OpenDatabase("C:\Users\PNRao\Documents\MyDatabase.accdb")
' Create a table with three fields.
DBase.Execute "CREATE TABLE MyTable " _
& "(EName CHAR, ENumber INT, ELocation CHAR);"
DBase.Close
End Sub
Here is the following VBA procedure to delete table from a specific database using VBA.

'Delete table from a specific database using VBA
Sub sbDelete_Table()
Dim DBase As Database
'
'Open Databse
Set DBase = OpenDatabase("C:\Users\PNRao\Documents\MyDatabase.accdb")
' Create a table with three fields.
DBase.Execute "DROP TABLE MyTable;"
DBase.Close
End Sub
Here is the following VBA procedure to the access database table using VBA.

'Add or Insert records to the access database table using VBA
Sub sbAdd_Records_Table()
Dim DBase As Database
Dim strSQL As String
'
'Open Databse
Set DBase = OpenDatabase("C:\Users\PNRao\Documents\MyDatabase.accdb")
strSQL = "INSERT INTO MyTable values('John2',12345,'U.S');"
' Adding records the table
DoCmd.RunSQL strSQL
DBase.Close
End Sub
Here is the following VBA procedure to update records in the access database table using VBA.

'Update records in the access database table using VBA
Sub sbUpdate_Records_Table()
Dim DBase As Database
Dim strSQL As String
'
'Open Databse
Set DBase = OpenDatabase("C:\Users\PNRao\Documents\MyDatabase.accdb")
strSQL = "Update MyTable set ELocation='U.K' where ENumber=12345;"
' Updating records the table
DoCmd.RunSQL strSQL
DBase.Close
End Sub
Here is the following VBA procedure to delete records in the access database table using VBA.

'Delete records in the access database table using VBA
Sub sbDelete_Records_Table()
Dim DBase As Database
Dim strSQL As String
'
'Open Databse
Set DBase = OpenDatabase("C:\Users\PNRao\Documents\MyDatabase.accdb")
strSQL = "Delete from MyTable where ENumber=12345;"
' Deleting records the table
DoCmd.RunSQL strSQL
DBase.Close
End Sub

10+ MS Access VBA Interview Questions and Answers

More MS Access VBA Interview Questions and Answers with Examples

MS PowerPoint VBA Interview Questions and Answers with Examples

Here are the most commonly asked MS PowerPoint VBA Questions and Answers covered from Basics of VBA Programming.

Here is the following VBA procedure or macro to create new PowerPoint Presentation.

Sub Create_Presentation()
Presentations.Add
End Sub
Here is the following VBA procedure or macro to add slide in a presentation.

Sub Create_Presentation_WithSlide_Ex1()
With Presentations.Add
.Slides.Add Index:=1, Layout:=ppLayoutTitle
End With
End Sub
'Or
Sub Create_Presentation_WithSlide_Ex2()
With Presentations.Add
.Slides.Add 1, 1
End With
End Sub
Here is the following VBA procedure to create new PowerPoint Presentation and add slide.

'Create new PowerPoint Presentation and add slide
Sub Create_Presentation_WithSlide_Ex2()
With Presentations.Add
.Slides.Add 1, 1
End With
End Sub
Here is the following macro to save PowerPoint Presentation.

Sub Create_Save_Presentation()
'Variable Declaration
Dim NewPres As Presentation
'Create new Presentation
Set NewPres = Presentations.Add
'Your statements do something
'Save Presentation in a folder
NewPres.SaveAs FileName:="d:/TestPresentation.pptx"
End Sub
Here is the following macro to delete 1st slide in a PowerPoint Presentation.

Example 1:

Sub DeleteSlide_Presentation_Ex1()
ActivePresentation.Slides(1).Delete
End Sub

Example 2:

'Delete 3rd slide in a presentation
Sub DeleteSlide_Presentation_Ex2()
ActivePresentation.Slides(3).Delete
End Sub

Read More MS Powerpoint VBA Interview Questions and Answers

10+ MS PowerPoint VBA Interview Questions and Answers with Examples

MS Word VBA Interview Questions and Answers with Examples

Here are the most commonly asked MS Word VBA Questions and Answers covered from Basics of VBA Programming.

Here is the following VBA macro to create a new Word document.
‘Create New Word Document

Sub Create_Documnent()
Documents.Add
End Sub
Here is the following VBA procedure to create a word document from the existing word documnet

'Create new word document based on existing word document
Sub Create_Doc_ReadOnly()
Documents.Add Template:="D:/Test.doc", NewTemplate:=True
End Sub
Here is the following VBA procedure to create a word document as a read only document.

'Open a Existing Word Document (Read Only Document)
Sub Open_Doc_ReadOnly()
Documents.Open FileName:="D:/Test.doc", ReadOnly:=True
End Sub
Here is the following VBA code to save a word document.

'Save Word Document if already not saved
Sub Save_Documnent()
If ActiveDocument.Saved = False Then
ActiveDocument.Save
End If
End Sub
Here is the following VBA procedure to SaveAs a word document.

'SaveAs Word Document if already not saved
Sub SaveAs_Documnent()
ActiveDocument.SaveAs ("d:/Test.doc")
End Sub

Read More MS Word VBA Interview Questions and Answers

10+ MS Word VBA Interview Questions and Answers with Examples

MS Outlook VBA Interview Questions and Answers with Examples

Here are the most commonly asked MS Outlook VBA Questions and Answers covered from Basics of VBA Programming.

Here is the following VBA procedure to create a new message using Outlook.

'Create a new message using Outlook
Sub Create_Message()
'Variable Declaration
Dim OLApp As New Outlook.Application
Dim oMessage As MailItem
'Create objects
Set OLApp = New Outlook.Application
Set oMessage = OLApp.CreateItem(olMailItem)
With oMessage
.To = "Person_Name@domain.com"
.Subject = "Test Email"
.Body = "This is a test message."
.Display
End With
Set objMail = Nothing
Set objOL = Nothing
End Sub
Here is the following VBA procedure to send a new message using Outlook

'Send a new message using Outlook
Sub Send_Message()
'Variable Declaration
Dim OLApp As New Outlook.Application
Dim oMessage As MailItem
'Create objects
Set OLApp = New Outlook.Application
Set oMessage = OLApp.CreateItem(olMailItem)
With oMessage
.To = "emailID@domainname.com"
.Subject = "Test Email"
.Body = "This is a test message."
.Send
End With
Set objMail = Nothing
Set objOL = Nothing
End Sub
Here is the following VBA procedure to add attachment to a message using Outlook.

'Add attachment to a message using Outlook
Sub Add_Attachment_Message()
'Variable Declaration
Dim oMessage As Outlook.MailItem
Dim oAttachment As Outlook.Attachments
'Create Objects
Set oMessage = Application.CreateItem(olMailItem)
Set oAttachment = oMessage.Attachments
'Add attachment
oAttachment.Add "D:/Test.doc", olByValue, 1, "Test"
oMessage.Display
End Sub
Here is the following VBA procedure to add attachment and send a message using Outlook.

'Add attachment and send a message using Outlook
Sub Send_Message_With_Attachment()
'Variable Declaration
Dim oMessage As Outlook.MailItem
Dim oAttachment As Outlook.Attachments
'Create Objects
Set oMessage = Application.CreateItem(olMailItem)
Set oAttachment = oMessage.Attachments
'Add attachment
oAttachment.Add "D:/Test.doc", olByValue, 1, "Test"
'Add message details
With oMessage
.To = "emailID@domainname.com"
.Subject = "Test Email"
.Body = "This is a test message."
.Send
End With
End Sub
Here is the following VBA procedure to create a Task in outlook.

Create a Task
Sub Create_Task()
'Variable Declaration
Dim Task As TaskItem
'Create object
Set myTask = Application.CreateItem(ItemType:=olTaskItem)
End Sub

Read More MS Outlook VBA Interview Questions and Answers

10+ MS Outlook VBA Interview Questions and Answers with Examples

VBA Interview Questions and Answers PDF – Free Download pdf file

You can download the free VBA Interview Questions and Answers PDF with Examples Explained.

VBA Interview Questions and Answers PDF – Free Download

Simple and Basic VBA Interview Questions and Answers for Beginners with Examples

Below are the 15+ Basic VBA Questions with examples for VBA beginners. Please refer these example VBA Basic Examples if you are a fresher or just beginner. This will be helpful to answer the basic VBA Questions.

Basic VBA Interview Questions and Answers with Examples

Advanced VBA Interview Questions and Answers for Experienced

Below are the 100+ examples on Advanced VBA Problems with solutions. Please refer these Advanced VBA Examples if you are attending for a experienced job/position profile requirement.

Advanced VBA Interview Questions and Answers with Examples

12 Comments

  1. Rajya Lakshmi March 23, 2015 at 5:07 PM - Reply

    Hi Team,

    Awesome! Thanks for the most useful faqs.

    Regards,
    Raji

  2. Suresh January 19, 2016 at 5:22 PM - Reply

    Wow!!!!… Useful Questions and Answers..
    Thanks for giving this..

  3. Venkat February 7, 2016 at 12:50 AM - Reply

    Very useful. Thanks for helping us!!

  4. S Das April 8, 2016 at 4:02 PM - Reply

    Good Work

  5. Soumya June 16, 2016 at 8:35 PM - Reply

    Good work …looking some tips for class module also

  6. Sanjeev Sharma July 28, 2016 at 6:06 PM - Reply

    Thanks for providing such a valuable information from you!!!

    !!!!!………This will truly helpfull for all of us… !!!!!

  7. Sai October 4, 2016 at 11:43 AM - Reply

    Very helpful thanks

  8. Arun Pandey December 28, 2016 at 9:48 PM - Reply

    there are several spelling mistakes in your content please update that part and make your website easier to read and understand

    rest all the content was good and helpful;

  9. kehsav December 31, 2016 at 4:26 PM - Reply

    Hi all,

    I have a userform on a worksheet. Now, I open anothe workbook, the userform still stays on top of all the workbooks. However, if I open a new workbook(new instance of excel), then it does not show. But that would help me for nothing.

    Can anybody help me in this. I need the userform to be a part of the excel which I open. not for all workbooks.

    Few comments before I complete: This was working as intended. All of a sudden, I messed up with the code and it burnt out.
    Secondly, the ShowModel of userform is set to False as I need to hide the workbook when userform opens. Hence, I cannot set that to true.

    Any suggestions are welcome. Please help

  10. Rahul January 2, 2017 at 2:19 PM - Reply

    yes its interview saver questions. Thanks for the questions…………

  11. Ram April 4, 2017 at 3:51 PM - Reply

    Hi,

    I want to ask a answer. When I open VBE editor then show me a message.

    Is that possible or not.

    If it is possible. Then please tell me, how can I do.

    Thanks
    Ram

Leave A Comment