Thanks for replies guys, will give some of the ideas a go at work
next week.

Just one more Q (for now anyways) - how do I get the textbox entry
(numeric) to pass to sheet  as a negative (This would be as a result
of selecting one of two other option buttons  on the main form  (ie
one for credit & one for debit)