View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Rudski[_2_] Tom Rudski[_2_] is offline
external usenet poster
 
Posts: 6
Default Application.wait & Blinking Connector

Is there a VB command that can make a spreadsheet 'wait'
without using the VBA Application.Wait command. So I can
wait less than a second. I tried the TimeValues but it
doesn't allow msec, just sec.

I am trying to 'blink' a 'connector' by using
the '.visible' function, 'RGB' color changing and
the 'Wait' statement. It works but not real clean.

If I run the Sub() 'For 1 to 50 by 1' it runs slow and
blinking does look right. But when I press the 'Esc' key
the routine still processes thru '50' and the blinking
looks very good.

Any ideas

TIA