Insert row if box on userform is checked
 

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!

Insert row if box on userform is checked
 

So what is your question??



"Steph" wrote in message
...
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!

Insert row if box on userform is checked
 

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?

"Kevin Mitchell" wrote in message
...
So what is your question??



"Steph" wrote in message
...
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!