# How to Make a Checklist in Excel Without Developer Tab

Get FREE Advanced Excel Exercises with Solutions!

To make a list updated in an Excel worksheet, generally, we use a checkbox. In this article, using a checkbox we are going to check or uncheck a particular item in our list. So, to accomplish the task we will first add a checkbox in the worksheet. In this article, we will discuss how to make a checklist in Excel without using the developer tab.

## How to Make a Checklist in Excel Without Using Developer Tab

In this article, we are going to use a dataset of the attendance of students in a class. Now we will checkboxes beside each student and mark with tick marks who are present in the class. Here is an image of our sample dataset.

VBA is used to carry out a number of activities. Additionally, we can utilize this to include checkboxes in our worksheet.

📌 Steps:

• First, launch the Microsoft Visual Basic for Applications window by pressing Alt + F11.

• Second, pick Module under Insert. A window for the module will show up.

• In the Module, type the code as follows and Run the VBA like the following image:
``````Sub Add_Checkbox()
Dim x As Range
Dim y As checkbox
Dim yRange As Range
On Error Resume Next
Set yRange = Application.InputBox(Prompt:="Select range", Type:=8)
If Err.Number <> 0 Then Exit Sub
On Error GoTo 0
For Each x In yRange
Set y = yRange.Parent.CheckBoxes.Add(0, 1, 1, 0)
With y
.Top = x.Top + x.Height / 2 - y.Height / 2
.Left = x.Left + x.Width / 2 - y.Width / 2
.Locked = False
.Caption = ""
End With
Next x
End Sub``````

• An Input box will appear after running the VBA. We will add a checkbox in the Attendance column so we select the cells in that column which is D5:D13.

• After clicking OK, the outcomes will look like the picture below.

• Right-click on the mouse to add some text beside the checkbox.

• Now we have marked the checkbox beside Present and the final result is shown in the below image.

## How to Make a Checklist in Excel from Developer Tab

However, using the Developer tab’s options is the easiest way to add a checklist in Excel. So, in this section, we will show how to add the Developer tab in your Excel if it is missing, and then will show how to create a checklist by using it.

In the following steps, we have elaborated the procedures of making a Checklist in Excel from the Developer Tab.

📌 Steps:

• Some Excel users may not have the Developer tab in their ribbon like the one below where the Developer tab is missing.

• To solve this issue, Right mouse click on the ribbon >> select Customize the Ribbon…

• In the Customize Ribbon, we will mark the box beside the Developer.

• Next, choose the Insert option under the Developer menu. Afterward, under the Form Controls, choose the Check Box.

• Subsequently, in the D5 cell, create a checkbox similar to the one in the below illustration.

• When we stop sketching, a box labeled Check Box 1 will appear. However, we added a customized name Present instead of Check Box 1.

• We will drag the fill handle down to copy cell D5.

• Here is the final outcome in the image below.

## Conclusion

Follow these steps and stages on how to make a checklist in excel without the developer tab. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section of our blog ExcelDemy.

## Related Articles

Al Ikram Amit

Hello, I'm Amit, a BUET graduate with a passion for Excel. Currently, I work as an Excel & VBA Content Developer at ExcelDemy, contributing insightful articles to the blog. I enjoy sharing my knowledge with others and always look for opportunities to grow as an Excel expert. Feel free to reach out if you need assistance or want to discuss the latest trends in Excel. Let's excel together in the world of data manipulation and analysis!

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF