Message Box - Help Needed

[rexman]

I have a userform with a ComboBox and from there the user can select any one of 30 items.

Also on the userform I have a Command button, when this button is selected I need a message box to appear based on the value in the ComboBox.

The message box needs to tell the user which sheet or sheets they now have to complete.

Here are a couple of examples:

First Example

ComboBox value "Monday"

MessageBox to read "Now please action the following sheet/s"
Sheet5

Second Example:

ComboBox value "Period 1"


MessageBox to read "Now please action the following sheet/s"
Summary
Year2
Sheet3

I will have 30 different options so really need some help/advice on this.