Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying drop down boxes | Excel Discussion (Misc queries) | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Copying Tick Boxes | Excel Worksheet Functions | |||
List boxes/combo boxes | Excel Programming |