Creating a button in VBA, then handling button clicked

Hi,

As I had mentioned to Jens at the time of the course, I have been trying without much success to achieve the following when a macro is run:
- the macro creates/shows on screen a couple of buttons,
- then it waits for one of them to be pressed
- depending on which button is pressed, a different sub is run
- apart from the other things the button subs would do, they would either delete the original button(s) created previously, or hide them,
- the sub also creates another button, which when pressed would create the first original buttons, or make them visible.

I have been able to create a User Form with buttons, but it just does not look good with the border, etc (and the solutions I have seen to hide the border and top bar are ridiculously complicated).

The easy ways to create a button with buttons.add do that indeed, and assign a sub to the button, but they do not make the macro stop and wait for the user to press a button in the way Excel stops when a User Form is shown.

To help understand what I a trying to do, imagine a quiz: the macro shows you a question (or a foreign word) with three buttons: know it well, know it somewhat, and don't know it. The fourth button could be End, to allow exit at any time. As you press a button, the macro will make some changes to a database, then show another word with three buttons.

Happy to provide any detail that may be helpful. Thanks in advance.
Atanas