VBA Forms - how open and close?????

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

grant@technologyworks.co.nz - 09 May 2008 06:05 GMT

It defies my how the most simple action is not documented anywhere
( that I can find)

I'm running Win XP, Outlook 2000

I have created a VBA form in the VB Editor, added some text boxes with
vb code behind them. I can click on the Run Macro button to display
this form in preview mode and I can enter data and my code
works...great.

But how do I call and open this form from a menu item on a toolbar on
Outlook??????

All the help reference is to Outlook forms and publishing etc, nothing
about vba forms.

Any suggestions appreciated

Thanks in advance

Grant

Reply to this Message

Michael Bauer [MVP - Outlook] - 09 May 2008 06:35 GMT

Public Sub CallForm()
    Dim var as YourForm
    Set var=New YourForm
    var.Show
End Sub

The next time use for programming issues *.public.outlook.general, please.

Signature

Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>

Am Thu, 8 May 2008 22:05:21 -0700 (PDT) schrieb grant@technologyworks.co.nz:

> It defies my how the most simple action is not documented anywhere
> ( that I can find)
[quoted text clipped - 17 lines]
>
> Grant

Reply to this Message

grant@technologyworks.co.nz - 09 May 2008 10:45 GMT

On May 9, 5:35 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
wrote:

> Public Sub CallForm()
> Dim var as YourForm
[quoted text clipped - 34 lines]
>
> > Grant

Great, that works...but now how do I close it?

var.close is not recognised???

Reply to this Message

Michael Bauer [MVP - Outlook] - 09 May 2008 12:54 GMT

Unload var
Set var=Nothing

Signature

Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>

Am Fri, 9 May 2008 02:45:47 -0700 (PDT) schrieb grant@technologyworks.co.nz:

> On May 9, 5:35 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
> wrote:
[quoted text clipped - 40 lines]
>
> var.close is not recognised???

Reply to this Message

grant@technologyworks.co.nz - 14 May 2008 21:41 GMT

On May 9, 11:54 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
wrote:

> Unload var
> Set var=Nothing
[quoted text clipped - 55 lines]
>
> > var.close is not recognised???

Thanks

All working sweet now

Reply to this Message