Syntax for Show/Hide using a form variable

[insomniac53]

I'm writing a subroutine called CreateFormTextBox which does exactly that - creates a text box on a specified form, puts it in the right place, formats it and fills it with a value - all done through passing a few parameters. And it works! However, the very simple Show and Hide don't work when used in conjunction with the same form variable. Here's the test sub:

Sub test()
    Dim f As MSForms.UserForm
    Set f = MyTestForm
    CreateFormTextBox(f, [form name and various other parameters])
    f.Show
    MsgBox "Done"
    f.Hide
End Sub

The 'f' variable passes as a parameter without a problem, yet the Hide and Show will only work if I use the full form name. Any suggestions why this is happening? Thanks.

 

[VoG]

Maybe XL97: How to Display a UserForm Whose Name Is in a Variable

 

[insomniac53]

Thanks. Had a quick look and tried

VBA.UserForms.Add(f).Show

but no luck. Will read and check.

 

[insomniac53]

Can't get this to work. Seems to be for Excel 97; I'm using 2013.