visual basic macro help

minendo

Elite Member
Aug 31, 2001
35,560
22
81
Writing a macro to communicate between a scale and Excel, but am having some trouble since it has been years since I've programmed last.

Basically have it working, but not sure how to modify it to do exactly what I want. Here is the code so far:

Now all I need to do is have it pause between weights. We currently have it set so that you have to press a button on the scale to record the weight to Excel, but after it records the weight it faults out.

Any ideas?