Results 1 to 5 of 5

Thread: Adding a waiting 3D animated icon to code
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    424
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding a waiting 3D animated icon to code

    Hello all,

    My code is working as intended.
    There is a long waiting period as a consequence of the code run that I would like to call a 3D animated model I have to just run onscreen while the code is running in the background.
    I cannot figure out how to call it from VBA to appear as this happens.

    Anyone have an idea?

    DThib

  2. #2
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    424
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding a waiting 3D animated icon to code

    Any ideas?

    DThib

  3. #3
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,898
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding a waiting 3D animated icon to code

    .
    Maybe this will give you a start :

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=19

  4. #4
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    424
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding a waiting 3D animated icon to code

    Thank you,

    I have been trying that code. The animated icon I am using is from the Insert menu images.
    I would like for it to run while the macro is executing code in the back. It takes a couple of minutes due to the content.

    I am not sure if there is an easy way to just call the animated icon, but I am trying to not bog down the code anymore than I have to.

    If it is not possible, that is OK.

    DThib

  5. #5
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,898
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding a waiting 3D animated icon to code

    .
    Everything I've learned involves animated GIF and using the web browser control. Not exactly what you are seeking.

    The thought behind the link provided is similar to creating a PROGRESS BAR in a userform. Instead of the bar the code would load the animated GIF.

    Maybe between example code of a progress bar (tons of examples on the internet and forums) and loading the GIF you could create what you are seeking.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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