VBA code to popup message box and choose the header data out of multiple choices

Dear all,

I'm new in the learning phase with macros, vba codes and so on.

I'm building a macro which I want to use for multiple lists, which the are used for multiple purposes, what changes in the lists is only the header.

What I would like to know is if:
- is there a chance to build a kind of message box popup on which appears the multiple header titles I want?
- within the popup I can choose the header title I want? (the choosen header will apear in my list)
- after choosing the header title the macro continues to run up to the end.

Hope I make myself understanding and sorry for not using tecnical tearms.

Thanks in advance

Hi and welcome!
You could show UserForm with your multiple chooses and after you made choise - save it in some variable and close UserForm.

Dear both, many thanks for your inputs.

As I'm in the learning phase, learning by doing/error the best to do is to go to the link posted by IonutC...it looks quite complete for what I want.

Merry Christmas and happy new year