This maybe?


Code:
--------------------
private sub cmdOK_click()

If ckbOne.value = true then
Activesheet.cells(1, 1).value = "blah"
Activesheet.cells(2, 1).value = "blah"
End if

If ckbTwo.value = true then
Activesheet.cells(1,2).value = "blah2"
Activesheet.cells(2,2).value = "blah2"
End if

End sub

--------------------

etc.


--
Ouka
------------------------------------------------------------------------
Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988
View this thread: http://www.excelforum.com/showthread...hreadid=502338