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

Re: VBA Forms - how open and close????? by Michael

Michael
Thu May 08 22:35:27 PDT 2008



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 grant@technologyworks.co.nz:

> 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

Re: VBA Forms - how open and close????? by grant

grant
Fri May 09 02:45:47 PDT 2008

On May 9, 5:35 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
wrote:
> Public Sub CallForm()
> Dim var as YourForm
> Set var=3DNew 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=3D6=E2=8C=A9=3Den>
>
> Am Thu, 8 May 2008 22:05:21 -0700 (PDT) schrieb gr...@technologyworks.co.n=
z:
>
> > 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

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

var.close is not recognised???



Re: VBA Forms - how open and close????? by Michael

Michael
Fri May 09 04:54:13 PDT 2008


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 grant@technologyworks.co.nz:

> On May 9, 5:35 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
> wrote:
>> 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
gr...@technologyworks.co.nz:
>>
>>> 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
>
> Great, that works...but now how do I close it?
>
> var.close is not recognised???

Re: VBA Forms - how open and close????? by grant

grant
Wed May 14 13:41:40 PDT 2008

On May 9, 11:54 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
wrote:
> Unload var
> Set var=3DNothing
>
> --
> Best regards
> Michael Bauer - MVP Outlook
>
> : Outlook Categories? Category Manager Is Your Tool:
> : <http://www.vboffice.net/product.html?pub=3D6=E2=8C=A9=3Den>
>
> Am Fri, 9 May 2008 02:45:47 -0700 (PDT) schrieb gr...@technologyworks.co.n=
z:
>
>
>
> > On May 9, 5:35 pm, "Michael Bauer [MVP - Outlook]" <m...@mvps.org>
> > wrote:
> >> Public Sub CallForm()
> >> Dim var as YourForm
> >> Set var=3DNew 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=3D6=E2=8C=A9=3Den>
>
> >> Am Thu, 8 May 2008 22:05:21 -0700 (PDT) schrieb
>
> gr...@technologyworks.co.nz:
>
>
>
> >>> 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
>
> > Great, that works...but now how do I close it?
>
> > var.close is not recognised???

Thanks

All working sweet now