Check Boxes

[AB1571]

I am creating a rather small excel sheet. Only 4 columns, but it will become quite lengthy. I need a check box in it to use as the case goes to Appeal status. So, what I would like to do is for that check box, which I will have in column 1A. But once I enter a name in column 1B, I would like a new check box entered in row 2a. Is hat possible? Or do I have to manually enter that check box every time?



I am sure this is a super simple question.

 

[Kamolga]

Hi,

If you right click sheet name, click on view code and paste this

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B:B")) Is Nothing Then
     
    ActiveSheet.CheckBoxes.Add(Cells(Target.Row + 1, "A").Left, Cells(Target.Row + 1, "A").Top, Cells(Target.Row + 1, "A").Width, Cells(Target.Row + 1, "A").Height).Select
        With Selection
        .Caption = ""
        .Value = xlOff
        .LinkedCell = "A" & Target.Row + 1
        .Display3DShading = False
        End With
    End If
End Sub

You will get a checkbox in A row+1 if you enter a value in column B. The checkbox is linked to its cell (so when you click a checkbox in A3, it will write true or false in A3). Easier is to get column A a wite font for user not to see it.