Responding to your MsgBox question:

It is hardly more efficient or clever but you could build a String
variable that varies with the value of the ComboBox and use the String
variable in the MsgBox's prompt.

Hth,
Merjet