- Code: Select all
Dim cb1 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 7, 30, 30)
cb1.CheckState = CheckState.Unchecked
cb1.Text = ""
Dim cb2 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 8, 35, 35)
cb2.CheckState = CheckState.Unchecked
cb2.Text = ""
Dim cb3 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 9, 40, 40)
cb3.CheckState = CheckState.Unchecked
cb3.Text = ""
Dim cb4 As Core.ICheckBox = sheet.CheckBoxes.AddCheckBox(50, 10, 45, 45)
cb4.CheckState = CheckState.Unchecked
cb4.Text = ""
I supposed to see 4 checkboxes at row 50, column 7, 8, 9 and 10. However, what I got is 4 checkboxes at row 50 and column 1 (column A), overlaying each other. See attached photos. I'm using Net 3.5 and excel 2019