A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Launching an UserForm from a cutomised form



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 9th 07, 03:00 PM posted to microsoft.public.outlook.program_forms
Tof
external usenet poster
 
Posts: 7
Default Launching an UserForm from a cutomised form

Hello everybody,

I apologize for my english, but it's not my mother's tongue.

I've created an UserForm in VBA (Outlook 2003). It's an userfom like the
one that is lauching when you click on the "Categories" button, but with
my personnal list of item (just a little window, with a liste of item to
choose).

I want to know if it is possible to launch this Userform from a customised
form : I would like to add a button to my form that will launch this UserForm.
Is it possible, and if yes, how ?

Thank in advance, and sorry again for my english.
Sincerly,
Tof


Ads
  #2  
Old January 9th 07, 03:08 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Launching an UserForm from a cutomised form

Yes, it's possible, but not a supported operation. Write a Public procedure in your ThisOutlookSession module to launch the userform. You can then call that procedure from your custom form's script with Application.My_Procedure_Name.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Tof" wrote in message .fr...
Hello everybody,

I apologize for my english, but it's not my mother's tongue.

I've created an UserForm in VBA (Outlook 2003). It's an userfom like the
one that is lauching when you click on the "Categories" button, but with
my personnal list of item (just a little window, with a liste of item to
choose).

I want to know if it is possible to launch this Userform from a customised
form : I would like to add a button to my form that will launch this UserForm.
Is it possible, and if yes, how ?

Thank in advance, and sorry again for my english.
Sincerly,
Tof


  #3  
Old January 9th 07, 03:49 PM posted to microsoft.public.outlook.program_forms
Tof
external usenet poster
 
Posts: 7
Default Launching an UserForm from a cutomised form

Hello Sue Mosher [MVP-Outlook],

Thank you very much for your so quick answer ! (8 minutes : faster than santaClaus
! )

Could you give me a little bit more precision lease. I'm beginning in Outlook
programing...and it's a little hard for me.

Perhaps could you gvie me just some links to find some documentation about
that procedure (I guess that you are very busy and don't have always time
to explain all to every beginners that is coming here )

Sincerly,
Tof


  #4  
Old January 9th 07, 03:58 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Launching an UserForm from a cutomised form

If your user form is named MyForm, this code goes in ThisOutlookSession in VBA:

Public Sub ShowMyForm()
MyForm.Show
End Sub

And this code would be the event handler for a command button on your custom form named CommandButton1:

Sub CommandButton1_Click()
Application.ShowMyForm
End Sub

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Tof" wrote in message .fr...
Hello Sue Mosher [MVP-Outlook],

Thank you very much for your so quick answer ! (8 minutes : faster than santaClaus
! )

Could you give me a little bit more precision lease. I'm beginning in Outlook
programing...and it's a little hard for me.

Perhaps could you gvie me just some links to find some documentation about
that procedure (I guess that you are very busy and don't have always time
to explain all to every beginners that is coming here )

Sincerly,
Tof


  #5  
Old January 9th 07, 08:00 PM posted to microsoft.public.outlook.program_forms
Tof
external usenet poster
 
Posts: 7
Default Launching an UserForm from a cutomised form

Hello Sue Mosher [MVP-Outlook],

Thank you very much for your answer.
It's very precious for me !

And thank you also for your book , that I've finally find in France (and
in french ! )
It's very helpful (even if the only one that I've found was (I'm not sure
of the english title) "Learn Outlook 2000 Programming in 24 hours")
If think I'll spend 24 month instead ! But it's enough for me, and for
beginning.

Good Evening
Sincerly
Tof


  #6  
Old January 9th 07, 10:02 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Launching an UserForm from a cutomised form

That's a very old book, and many things have changed since then, so please feel free to ask (even en francais) if you have any questions.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Tof" wrote in message .fr...
Hello Sue Mosher [MVP-Outlook],

Thank you very much for your answer.
It's very precious for me !

And thank you also for your book , that I've finally find in France (and
in french ! )
It's very helpful (even if the only one that I've found was (I'm not sure
of the english title) "Learn Outlook 2000 Programming in 24 hours")
If think I'll spend 24 month instead ! But it's enough for me, and for
beginning.

Good Evening
Sincerly
Tof


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Build a userform on excel to copy contacts from outlook 2003 Oggy Outlook - General Queries 4 January 2nd 07 07:13 PM
Build a userform on excel to copy contacts from outlook 2003 Oggy Outlook and VBA 4 January 2nd 07 07:13 PM
Launching IE7 from OE6 PeteH Outlook Express 3 December 30th 06 07:48 PM
Problem with first launching of MS Outlook Nick Outlook - General Queries 1 August 3rd 06 08:35 PM
UserForm ShowModal strange behaviour David OShea Outlook - Using Forms 1 March 14th 06 06:58 PM


All times are GMT +1. The time now is 08:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.