How to Display References Dialog Box in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset to Display the References Dialog Box

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.

Opening Reference to Display the References Dialog Box

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.

Reference Dialog Box to Display the References Dialog Box

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

Utilizing Reference Dialog box to Display the References Dialog Box

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

Result to Display the References Dialog Box

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

Steps:

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


Conclusion

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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo