creating command buttons

I am trying to create command button on a new toolbar which I click on and it opens a respective userforms.

I went through customise option ,but there is no specification on using it with forms.do i have to create a macro which will do a showform and attach a macro to it.

your help will be appreciated.

attached is the form which i try to open when clicked.

[Alex]

Yes, you need to create a simple macro which invokes a form. For example:

Sub ShowForm1()
    UserForm1.Show vbModal
End Sub

Then just go to Tools>Customization>Commands>Macros and add the ShowForm1 macro to the toolbar. It will show the form when clicked.

I hope this helps.

P.S. If you want the form to be floating (that is, so you can return to your document without closing the form), just use vbModeless constant in Form.Show instead of vbModal used in the above example.