FurRelKT wrote:
bobbo, again thankyou.
another question: I also would like to keep one blank row between the
myStr and the empty row (they have the formulas). I have found a way to
add the rows, while still keeping the formulas, by searching this site.
So the problem is, i want to keep at least one row between, then if
there insn't enough 'empty' rows left to input the rows, pop up the
question of how many rows to add.... OR another thought, keep the one
row between, if there isn't enough rows add another row to the sheet
(as many as what is needed for the input), but copy the formula's from
the above row...that seems like a better solution to me. what you
think?

additionally, by your suggestion of using the arrForm(1 to 20,1 to 5).
can i also make sure that the columns in the listbox are filled using
the columns? I am not sure how this works.
listbox1.ListColumn = 5

to get the result like this, can it be done?:

product | bankid | project | servtype | amount
1 -- ABC | ABCD | theproj | cross charge | 100.00
2 -- DEF | DEFG | another | vacation | 40.00

instead of what it is now...

1 -- ABC ABCD theproj cross charge 100.00
2 -- DEF DEFG another vacation 40.00

using the code:
lbxResults.AddItem (counter & " -- " & cboProduct.Value & " " &
cboBankID.Value & _
" " & cboProject.Value & " " & cboServType.Value &
" " & txtAmount.Value)

I think your best bet for dynamically inserting rows would be to name
the range that you want to insert rows above and if the row of where
the userform writes is one above it insert the row. The other stuff I
am not quite sure off yet. I am still a novice with this stuff because
I have only been learning it for a little more than a year.