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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,089,875
Messages
5,410,908
Members
403,333
Latest member
SH2020

This Week's Hot Topics

Top