MsgBox/ListBox/ComboBox

Hi, I am currently writing some vb code in excel.

I am at a stage where I want a messagebox to appear with a list of criteria to choose. I only have two criteria ("Profit Centre", "Business Area"). Then depending on what is chosen, the code works accordingly.

Can anyone help?

Thanks

You will need to use a userform with either a listbox or combobox on the userform.

If your list will always contain only the two choices you mentioned then you could also use option buttons on the userform and an OK button. After a selection is made and the OK button pressed the corresponding code could run.

Think about what style the selection option should take and let us know if you have any further questions.

HTH