Using VBA in outlook form

owen4512

Board Regular
Joined
Dec 10, 2014
Messages
56
Hi all,

I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form so I'm not sure how I reference the pages and combo box. The four pages are currently labelled as "Message", "P.2", "P.3", "P.4". The "Message" tab is where the user will select from the combo box.

I'm looking for something along the lines of the below;

Code:
Sub select_form()

If Me.combobox1 = "Test" Then
'i want this to open P.2


ElseIf Me.combobox1 = "Test2" Then
'i want this to open P.3


ElseIf Me.combobox1 = "Test3" Then
'i want this to open P.4
End If


End Sub
Any help is always appreciated.
 
Last edited:

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,095,985
Messages
5,447,704
Members
405,464
Latest member
milindighe

This Week's Hot Topics

Top