View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default Pointer to a userform

Hi,

how can I set a pointer to an existing userform.

I tried this to use in an module

public fME as Userform

function Set_Form()

fME.Height = 315
fME.Width = 390

end function

In the Userform Initialize section

Private Sub UserForm_Initialize()

Set fME = ME
Set_Form

End Sub

....

but I can't assign my userform to the global pointer (nor can I when I
substitute de ME to Userforms("myForm") or something like that.

Any help is appreciated
Jos Vens