Upon clicking on these button, their Caption will be displayed in the code of the calling function. Create a class module in your VBA project, name it as PremierExemple (ClassName property) and insert ...

Populate a userform combo box ... VBA code. Getting the combo box to update when the list updates requires a bit more work. You could update the list range every time you update it or you could ...

And, as long as I'm here, class modules are for creating your own programatic (code-only, no UI) objects -- the ADO data access objects are an example of that kind of object. User forms ...