F
flowtester
I could really use some help with one. I almost get it but then run
smack into a wall. It's hard to explain but I'll try my best.
Cell A1 receives it's data from another application. It's a pressure
reading.
The user needs to be able to adjust a control knob on a machine that in
effect, changes the value of A1 by controlling the pressure. That part
all works fine. The machine functions, A1 values change like they
should.
As A1 changes, the values of B1 and C1 change as well.
When the desired pressure is met, I have individual control buttons
that run macros to copy A1:C1 to 11 locations on the worksheet in
series.
I'm trying to automate the process so that A1 is monitored and upon
reaching a specified value, will run the macros in series.
To monitor A1, I use M1 as the preset value. When A1=M1 run the first
macro.
At that point, the process needs to wait while an adjustment is made to
the control knob and to another mechanical part. I need a short delay
for the adjustments to be carried out [application.wait with a value..I
have that figured out] As the adjustments are made, A1 <> M1 BUT when it
again equals A1, I want the next macro to run.
Application.wait seemed like the answer but it's not because while the
application.wait process is going on, A1 is sitting there in limbo and
the value is not changing while the adjustments are made.
As soon as the application.wait time has expired, my current code calls
the next macro and it's grabbing inaccurate data.
Any and all ideas are welcome! Please, someone that knows VB respond to
me on this. I'm 99% of the way to where I need to be and there's this
one last little hurdle...
smack into a wall. It's hard to explain but I'll try my best.
Cell A1 receives it's data from another application. It's a pressure
reading.
The user needs to be able to adjust a control knob on a machine that in
effect, changes the value of A1 by controlling the pressure. That part
all works fine. The machine functions, A1 values change like they
should.
As A1 changes, the values of B1 and C1 change as well.
When the desired pressure is met, I have individual control buttons
that run macros to copy A1:C1 to 11 locations on the worksheet in
series.
I'm trying to automate the process so that A1 is monitored and upon
reaching a specified value, will run the macros in series.
To monitor A1, I use M1 as the preset value. When A1=M1 run the first
macro.
At that point, the process needs to wait while an adjustment is made to
the control knob and to another mechanical part. I need a short delay
for the adjustments to be carried out [application.wait with a value..I
have that figured out] As the adjustments are made, A1 <> M1 BUT when it
again equals A1, I want the next macro to run.
Application.wait seemed like the answer but it's not because while the
application.wait process is going on, A1 is sitting there in limbo and
the value is not changing while the adjustments are made.
As soon as the application.wait time has expired, my current code calls
the next macro and it's grabbing inaccurate data.
Any and all ideas are welcome! Please, someone that knows VB respond to
me on this. I'm 99% of the way to where I need to be and there's this
one last little hurdle...