View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dcjohnson50@gmail.com is offline
external usenet poster
 
Posts: 1
Default COM add-in form show question

I'm developing a COM add-in for Excel using VB 6.0. So far, it works
well with one exception, I haven't been able to keep one of my forms
on top of Excel, yet be modeless.

My code to call the form is as follows:
MyForm.Show vbModeless

The Show function is defined as such:
--------------------------------------------
object.Show style, ownerform

ownerform Optional. A string expression that specifies the component
which "owns" the form being shown. For standard Visual Basic forms,
use the keyword Me
--------------------------------------------

The ownerform parameter is the key here, but so far it's kicking my
butt. I searched a few pages deep but didn't find anything. Any help
would be appreciated.

Thanks,
David