Inputs to trigger VBA code

Arduino would be a good choice for this application. It will provide the real world interface you need to connect the sensors to your computer. You might even be able to get the information to Excel via USB! I've been working on getting Arduino to interface with Excel. If anyone is interested, drop me a message!

Thank for the reply. I came to a dead end with this and so haven't done anything. Would still be interested if you have any info on how to integrate with excel.

Not sure how to build and connect either but I think there was a lot of guides on the web last time I looked.

Thanks, KAL