I have a user form in Excel that is filled at run time with variable number of CommandButtons named after values in spreadsheet.

So you end up with variable number of buttons named for example "Germany, England, Scotland etc.".

That works fine via Me.Controls.Add method!

NOW, I WANT TO KNOW WHICH BUTTON WAS CLICKED. HOW DO I DO THAT?

Thanks!