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