ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying list boxes (https://www.excelbanter.com/excel-programming/349280-copying-list-boxes.html)

ZipCurs

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.

Tom Ogilvy

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.




ZipCurs

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