View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Copying list boxes

try putting

DoEvents

prior to the capture.

--
Regards,
Tom Ogilvy

"ZipCurs" wrote in message
...
As a reference for the previous state, I would like to put a picture of a
list box next to the active list box. I have accomplished this so far by
creating a JPEG image of the list box next to it with a macro. The

problem
is that the copy is always of the previous state. I have tried Wait and
Refresh, but these do not seem to do anything for me.

Any help would be appreciated.