Thread: Launching form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Osawa Peter Osawa is offline
external usenet poster
 
Posts: 1
Default Launching form

Hi, I'm doing an Excel addin with VB6

I have created a button in Command Bar, but I'm unable to display a form.

I do this on my button click event:

(This declared: Dim mfrmAddIn As New frmAddIn)

Set mfrmAddIn = New frmAddIn
Set mfrmAddIn.VBInstance = VBInstance <--- "I don't know how to
translate it to Excel"
Set mfrmAddIn.Connect = Me
mfrmAddIn.Show