Thanks for help  so far - as I said I am a real beginner and trying
to get to grips with VBA(not going so well have to admit). I know
I'm probly tryna run b4 I can walk but I need to get this form
working in the next 6 weeks. I have several tutorials but none seem
to go in to this much depth working with userforms.

I am getting really confused and would appreciate some more pointers
eg

I have 3 frames  that each have a text  box in and 3 option buttons  A,
B & C

The idea is that whatever I input  in the 'frame' text box  and
depending on which option button is selected it will populate the
column in that spreadsheet & next available row.

I have 3 commandbuttons (ADD, CANCEL & CLEAR - which are working
(apart from the ADD obviously).

I also need to populate each spreadsheet with customer  Name & Account
from text boxes  in the main  form.i.e. if i only select one frame
input it only updates one sheet  with 'frame' input and customer
details BUT if use 2 or 3 it will populate 2 or 3 sheets  with frame
input and customer details



Customer Account Date (today)
Text Box Text Box Text Box
----------------------------------------------------
Frame 1 Text Box optbA optbB optbC
----------------------------------------------------
Frame 2 Text Box optbA optbB optbC
----------------------------------------------------
Frame 3 Text Box optbA optbB optbC
----------------------------------------------------