reload check box on user form

[Mikal]

I am looking for code that would look at a column, and if the cell is greater than "0" it would recheck the check box when the form is opened.any help would be appreciated.

 

[My Aswer Is This]

You would need something like this in your UserForm

Private Sub UserForm_Initialize()
If Sheets(1).Cells(1, 5).Value > 0 Then CheckBox1.Value = True
End Sub

 

[Mikal]

Thanks for the help, I was able to modify this and make it work.