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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,095,973
Messages
5,447,644
Members
405,460
Latest member
stuartbennett

This Week's Hot Topics

Top