ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Launching form (https://www.excelbanter.com/excel-programming/308907-launching-form.html)

Peter Osawa

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


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com