Quote Originally Posted by romperstomper View Post
For mine, you need to alter the Userform_Activate code to use:
    ufcap = Me.Caption
rather than:
    ufcap = Userform1.Caption
That now works a treat, Thank you very much the effect works really well with userforms for me.