Thread: UserForm usage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric[_27_] Eric[_27_] is offline
external usenet poster
 
Posts: 43
Default UserForm usage

I want a generic way to show a UserForm, which I coded as

Public Sub displayForm(form As UserForm, mode As Integer)
Debug.Assert mode = vbModal Or mode = vbModeless
Load form
form.Show mode
End Sub

The method fails,as the UserForm object does not support the Show method. My
question is why does the 'actual' form, which *is* a UserForm, work?
KeyMgtForm.Show vbModeless ----------- works fine

So, is there another object that I can cast the UserForm to that will work?

TIA