Excel formatting and combo box

I've been having this problem for the past couple of hours and can't seem to figure it out. I have a VB application that is writing data into an excel spreadsheet. It places the data into the spreadsheet using a loop function and every time a new item is going to be added it inserts a new row. The problem I am having is that the cell formatting is not being applied to the newly inserted row. How do I do this? I am using the xlBook.Application.Range(previousCell).EntireRow.S elect to select the previous cell and then xlBook.Application.Selection.EntireRow.Insert to insert the row.

Another problem I am having is I have a couple check boxes on this excel form and what I want to do is if a certian check box is selected in the VB application Id like to also select the certian check box on the excel sheet.

Thanks,
~Zach~

Ok well I figured out what I was doing wrong in the first problem, but I am still having problems with the check boxes.

Well the moderators can delete this post now, because I figured out what I was doing wrong. I guess before you can edit the check box control in excel from vb you must use the line of code in blue to activate it:



Thanks for reading,
~Zach~