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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Forum statistics

Threads
1,089,233
Messages
5,407,039
Members
403,118
Latest member
Nabilaal

This Week's Hot Topics

Top