Insert row if box on userform is checked

[Steph]

Hi everyone. We have a userfrom with multipage tabs on it (1 for each month
of the year). We are having users populate the form with actual data (ie
Monday we will have them update the July tab, but the Aug-Dec tabs will
still be blank). Then obviously the data writes to a 'database' worksheet.

Rather than having all 12 months ready in the database sheet, I'd like to
include a checkbox on each tab(month) of the form (some users won't have
actuals for every month). Then the user populates the month, he/she would
also check the box, which would insert a row on the database sheet, and
write to the inserted row. I have several named ranges, so I assume I can
use offset to tell excel where to insert the row.

Thanks!

 

[Kevin Mitchell]

So what is your question??

 

[Steph]

Sorry. If I put a checkbox on the form, how do i tell excel to first insert
a row, and then write to that row?