This tutorial will demonstrate how to display the references dialog box in Excel. When you are dealing with lots of VBA codes in a different worksheet in a specific workbook, then it is essential to maintain references. Otherwise, you will face difficulty in jumping from one VBA code to another. So, we use the references dialog box. So, it is important to learn how to display the references dialog box in Excel.
What Is a Dialog Box?
A dialog box in VBA code is used to mark a certain program module with proper naming. Suppose you are doing VBA codes of grading, odd/even, or coloring at the same time in a certain workbook, and in every worksheet, you have to use them differently. So, in that particular case, you have to name them properly using the reference box. Whenever you choose that certain reference box, the VBA code within it will come on the screen.
What Are Different Options of Dialog Box in Excel?
The Reference Dialog Box in Excel has different options. Among them, some are important. The description of these options is:
- Available References: This portion makes the whole list of the available references that exist in your current workbook. Whenever you put a defined name for a certain module, you will see it here.
- Priority Buttons: These buttons are used to move the references upward and downward on the list. It is very important if lots of references are used.
- Result: This portion displays certain pathways and names available in the references box.
- Browse: This portion adds more dialog boxes or libraries to the existing references.
Purposes of Dialog Box in Excel
The main purposes of using the reference dialog box are:
- It marks a certain VBA module with a specific defined name.
- With it, finding a certain VBA becomes very easy.
- It eases our work and time and decreases the possibility of any mistake.
Display the References Dialog Box: Step-by-Step Procedure
If you follow the steps correctly, you should learn how to display the references dialog box in Excel on your own. The steps are:
Step 1: Arranging Dataset
In this case, our goal is to arrange a dataset to play the references dialog box in Excel. We have the Value in Column B and the Even/Odd in Column C. We will use this dataset to understand the whole process.
Read More: How to Create a Dialog Box in Excel
Step 2: Finding References in Excel VBA
We want to find the references in Excel VBA by following the steps below.
- First, press the Alt + F11 options to open the VBA window.
- Next, go to the Insert > Module options.
- Then, insert the VBA code here.
Sub OddEven() Dim i As Integer For i = 5 To 11 If Cells(i, 2).Value Mod 2 = 0 Then Cells(i, 3).Value = "Even" Else Cells(i, 3).Value = "Odd" End If Next i End Sub
- Last, go to the Tools > References options.
Read More: How to Input Dialog Box in Excel VBA
Step 3: Displaying References in Excel VBA
Now, our target is to display the references dialog box in Excel by following the below steps.
- To begin with, after pressing the References option, you will see the References dialog box on your screen.
- In addition, if you tick the available references with the name, then after that, on the left side, it will show the list of the VBA window.
Read More: How to Display Excel Options Dialog Box
Step 4: Utilizing Reference Dialog Box in Excel
At this point, our target is to utilize the references dialog box in Excel by following the steps below.
- First, tick the desired reference boxes and press OK.
- Next, if you click on a certain reference cell, it will show you the pathway of that reference.
- Then, if you want to use it, simply press the Run option.
- Lastly, you will get the desired result.
Read More: Dialog Box Launcher in Excel
How to View Object Library in Excel
In this case, our target is to view the Object Library in Excel by following the steps below.
- First, go to the Tools > References options.
- Next, select the Microsoft Excel 16.0 Object Library option and click OK.
- Lastly, you will get the desired result.
Things to Remember
- We should use more reference books but with the desired names.
- When you are utilizing a certain reference dialog box, you can’t untick the Visual Basic Application option as you are using it.
- To run the codes, the file must be saved as an Excel Macro-Enabled Workbook. Otherwise, codes won’t work.
Download Practice Workbook
You can download the practice workbook from here.
Follow the above-described methods to display the references dialog box. Hopefully, these methods will help you to display the references dialog box in Excel. We will be glad to know if you can execute the task in any other way. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.