![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 ![]() beginning. Good Evening Sincerly Tof |
#6
|
|||
|
|||
![]()
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 ![]() beginning. Good Evening Sincerly Tof |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |