Floating panel with command buttons

[Rockhopper25]

Hi everyone, can anyone tell me how I can create a floating panel that I can add command buttons on to.

I want to start off with a button that says OPTIONS then when clicked it opens a floating panel which I can have 4 command buttons to do various things when clicked then have a close tab so that it dissappears when clicked again

similar kind of thing like in this picture

 

[sykes]

Use a "Userform" in your VBA project.
Put your buttons onto it, code the buttons, then when it's ready to use, show the userform, thus:

UserForm1.Show (modeless)

The modeless attribute will mean that the form can remain in view (and be moved around the page by the user) even when the other buttons' code is being run.
If you keep it as a standard userform, there will be a cross in the top right for the user to close when they wish, as normal.

 

[Trevor G]

You can achieve this through the VBA screen by creating a UserForm. Use Alt + F11 to take you into the VBA screen and then use the Insert Menu and UserForm.

You will have a toolbox which will allow you to add command buttons.

Question is what are you aiming to achieve as this now means working with VBA?