Mass Rate of Change Calculation

[Mgtrom]

First of all let me state that my coding ability is very limited.

I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1.

What I want to due is create a macro to calculate the mass rate of change (i.e. pounds per minute) by reading scale value, wait 5 seconds, read scale value again. Take change in weight divided by change in time.

Would also be nice to have a couple of active x controls to start/stop calculation. I know how to add the controls but do not know how to code them.

Thanks in advance.