Gradually Fade Userform Into View [Userform Fade Out Working Already]

This is my first post! Thank you all in advance!

I am looking to have a userform gradually fade into view...

I am creating a dashboard [win7x64/excel 2013] that will have activex buttons opening userforms. The code that I have acquired from this site [Many Thanks] and others uses Windows API calls to hide the userform titlebar and fade-out the userform. It looks great and works just as it is designed. I am basically looking to have the userform fade into view as it opens in the same manner that it fades out as it closes. I am thinking I need to mimic the "FadeAway" sub and create a "FadeIn" sub to handle this. Here is the current userform code [sample workbook attached]:

Please Login or Register  to view this content.

Hi Joseph (Josie?),

Thank you for your response! I am not sure if you are noticing this on your machine, but when the userform loads there is an initial flicker. My best guess is that the form quickly loads with zero transparency, is then set to fully transparent and then starts to gradually fade in to zero transparency again. Any suggestions on how we can overcome the initial flicker? (I will live with it if i have to...)

Other than that, thank you for adding the 64bit compatibility and for the help on the Fade In sub!

-Aaron

Good Morning Josie!

Both of your suggestions work great. The userforms now open and close very smooth. Thank you for taking the time to look at this problem for me!

- Aaron

I wanted to post a follow up to this topic:

I have added additional code that does the following:

- Loads a full screen, semi-transparent userform to serve as a screen dimming effect.

- Loads a secondary form on top of the background form with zero transparency. The effect of course to emphasize the secondary form.

It works great as is, however, i would like the background to fade away upon closing the userform. I have attached an example workbook. Because I am calling the secondary form from the background form Activate sub, when I close the secondary form, if I don't put "unload Me" in the "ShowSecondForm" sub it goes into a nasty form opening loop. Any ideas on how to fade out the background userform after fading out the secondary userform?

The code below is for the Background userform:UserformFade Part2.xlsm

Please Login or Register  to view this content.