UserForm Animation

[kayza]

Hi...
I have an userform which only has height 50, and when i call it with simple code userform.show, the userform height will slowly growing into specific value, for example 500.


I wonder, is this can be done with Macro VBA?


thanks in advance

 

[My Aswer Is This]

So when the UserForm opens the height is 50 and you want it to slowly grow in size to 500. Define "Slowly"
Do you want it to take 5 seconds to grow to 500 or 50 seconds or 5 minutes?
And how do you want to tell it what size to grow to? Do you want a Inputbox to popup asking what size?

Hi...
I have an userform which only has height 50, and when i call it with simple code userform.show, the userform height will slowly growing into specific value, for example 500.


I wonder, is this can be done with Macro VBA?


thanks in advance

 

[kayza]

I'm sorry for untidy or maybe unclear in describing what I really want. and hopefully this other example, can make more clearly.


So I have userform1 which I set the height properties with 50, and then I display the UserForm1 from the command button which I put it on the UserForm2. After the UserForm1 appears, the height properties of the UserForm1 will slowly change from 50 to 500 within 2 or maybe 3 seconds, so the UserForm1 will have an animation effect based on its high value automatically.


Thanks in advance. and sorry for my poor English spelling.