![]() |
Copying list boxes
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. |
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. |
Copying list boxes
Tom,
The DoEvents command did the trick. Thanks. "Tom Ogilvy" wrote: 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. |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com