Al Ikram Amit
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.
Download Practice Workbook
You can download the practice workbook from the following download button.
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 = ""
.Name = x.Address
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.
Read More: How to Make a Daily Checklist in Excel (2 Simple Methods)
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.
Read More: How to Make Checklist with Conditional Formatting in Excel
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.
