Hi,

I'm extremely new to VBA and I am looking for some advice and pointers on how best to do what I want.

I currently have a workbook setup that uses a Uder Form which submits data to worksheet within the same workbook. The workbook itself has now become rather large and as such I was wondering if it is possible to have the User Form in workbook A and have it add the data to Workbook B instead of a seperate sheet in workbook A.

Ideally (and much into the future) I would like to setup links between excel and access.

For now though would anyone please be able to suggest some ideas and possibly sample code that I could study/use/adapt.

I've attached a copy of my workbook for you to view.

Many thanks