Hello again,

So I have data exporting working correctly from my current form (thanks). Now I need to get data capture working, I have drivers and some code which interface with my ADC and I can pull data into my spreadsheet which is nice but I am having a bit of trouble thinking out where the code needs to be, if that makes sense.

My situation is my workbook is going to hold a lot of experiment runs, one per sheet. I will need some controls on each sheet to start datalogging on that sheet, and lock all other sheets controls to try and bullet proof it.
So how should I lay this sorta thing out as I am not to sure on the terminology of these things, have the data grabbing universal functions in a module then the button controls in the sheet?
Also is it possible to code this once, then when the user clicks new sheet it puts one in with the template from the first...

It would be nice to have all the test runs in one file but I could just do one per file if its too complicated.