View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
cdb cdb is offline
external usenet poster
 
Posts: 62
Default Problem running code behind a userform

Markus,

Just tried it and it still doesn't really do what I need (as I need the text
box to flash to make sure the users attention is got), so I have code to make
it visible and then hide if every 3/4 of a second. I think this is where I
have the problem because I just create an endless loop of displaying/hiding
the text box or userform (whichever way I try it) and I don't progress to the
next code.

Is there anyway I can run two losts of code in parallel?? (e.g. run my
update macro at the same time as continually looping through the hide/show
code)

Chris

"Markus Scheible" wrote:

Hi unknown,

maybe this is no answer to your question, but if you just
use the userform for displaying the alert while the macro
is working, just use a text box from shapes instead of the
userform, and you don't have all this trouble...

Best

Markus


-----Original Message-----
Message unavailable