Create Dependent Check Box Selection

[Dokat]

Hi,

Is it possible to create dependent check box and populate new list with check boxes based on prior selection? I know this can be done with drop down list however I will need to have multiple selection therefor dropdown is not an option. This can be done with PowerApps however I don't have access.

In below example user needs to be able to select Fruit and Vegetable or Vegetable and Meat with checkboxes to populate only corresponding results with check box. Is this possible, appreciate anyone's help.

Fruit	Apple
Fruit	Banana
Fruit	Strawberry
Vegetable	Lettuce
Vegetable	Eggplant
Vegetable	Pepper
Meat	Beef
Meat	Chicken Pork

 

[Akuini]

Are you talking about checkbox on a userform?
I suggest, instead of checkbox, you use 2 listbox. A listbox has multi-select functionality.

 

[Dokat]

Are you talking about checkbox on a userform?
I suggest, instead of checkbox, you use 2 listbox. A listbox has multi-select functionality.

Thank you for your reply and recommendation. I assigned the below code to the checkbox and it worked.

Sub UpdateList()
    Dim ws As Worksheet
    Dim lookupRange As Range, cell As Range
    Dim outputRow As Integer

    ' Set the worksheet
    Set ws = ThisWorkbook.Sheets("Calculator")

    ' Clear column D from row 7 onwards
    ws.Range("D7:D" & ws.Cells(ws.Rows.Count, "D").End(xlUp).Row).ClearContents

    ' Set the lookup range
    Set lookupRange = ws.Range("AK2:AK108")

    ' Initialize the output row
    outputRow = 7 ' Starting from row 7 (cell D7)

    ' Loop through each cell in the lookup range
    For Each cell In lookupRange
        ' If the cell value is TRUE (checkbox is checked), copy the corresponding value from column AB
        If cell.Value = True Then
            ws.Cells(outputRow, "D").Value = ws.Cells(cell.Row, "AJ").Value
            outputRow = outputRow + 1 ' Move to the next row
        End If
    Next cell
End Sub