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

[grant]

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

 

[Michael Bauer [MVP - Outlook]]

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.

--
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 (e-mail address removed):

 

[grant]

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.

--
Best regards
Michael Bauer - MVP Outlook

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

Am Thu, 8 May 2008 22:05:21 -0700 (PDT) schrieb (e-mail address removed):

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

var.close is not recognised???

 

[Michael Bauer [MVP - Outlook]]

Unload var
Set var=Nothing

--
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 (e-mail address removed):

 

[grant]

Unload var
Set var=Nothing

--
Best regards
Michael Bauer - MVP Outlook

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

Am Fri, 9 May 2008 02:45:47 -0700 (PDT) schrieb (e-mail address removed):

Thanks

All working sweet now