+ Reply to Thread
Results 1 to 2 of 2

Wait for image to change using VB

Hybrid View

  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    Wallingford, CT
    MS-Off Ver
    Excel 2007
    Posts
    1

    Wait for image to change using VB

    Hi,
    I wrote some code to change an image in my spreadsheet based on an input in a cell. The image is set to 1 then prints, change to image 2 then prints, change to image 3 then prints, ect...

    When I step through the code manually everything works perfectly; however, when I use the command button to run the code the images do not change. I have already tried screenupdating which did not work.

    Is there a way to wait until image changed before going to next command?
    Last edited by premacre16; 03-16-2013 at 11:33 AM. Reason: Description

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Wait for image to change using VB

    After your code issues the commands to remove or add images, issue a
    DoEvents
    command before printing, etc. This will allow time for the worksheet to respond to your commands.
    Gary's Student

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1