Launch a userform from toolbar instead of command button

Hi

I have written some userforms in excel and they currently work from a command button.

I want for them to launch from the quick access tool bar (like with macros).

Can anyone help with this.

Thanks

Just create a macro that launches your userform and assign it to a button on the quick access toolbar

Hi

Could you please explain how to do that

Sure, create a macro:

Public Sub ShowMyForm()
    MyForm.Show
End Sub

and assign it as you would with any other macro

Thank you works briliantly