If Statement Based on Cell Data

I am mapping data from an Excel spreadsheet into a fillable PDF. The last issue I'm running into is that I have 2 checkboxes in the PDF, FirstDraw and SecondDraw. In Column I of my Excel document, there is either a 1 or a 2 entered. How can I write an If statement to say if column I = 1 then check the box else move on. I would then do the same thing for the second checkbox. I know I can use a SendKeys " " to check the box but I'm not sure how it knows if it's a 1 or 2 in the cell.

Thank you.

Just off the top of my head you would do something like this:

If Sheets(datasheetname).Cells(row,9).value = 1 then
' do check box code (I assume you know how to do that)
Else
' do whatever you need to do for unchecked box
End If

Be sure to use the correct name for the data source worksheet and the correct row number in the Cells method reference.