I want to write a macro that will create a checkbox in
a cell that meets certain conditions. For example, if the cell or range of cells values fall between 1 and -1 then a macro would generate a checkbox in that cell or range of cells. Right now, I want this to happen when I activate a specified worksheet upon opening a workbook. Can anybody help? The beginning of my code looks like this:
a cell that meets certain conditions. For example, if the cell or range of cells values fall between 1 and -1 then a macro would generate a checkbox in that cell or range of cells. Right now, I want this to happen when I activate a specified worksheet upon opening a workbook. Can anybody help? The beginning of my code looks like this:
Code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Application.Range.Value <= 1 And Application.Range.Value >= -1 Then