How to assign the form in the command button.

[somani123]

Hello everyone!!!!

How r u? Hope you all are doing well.

I need your help. I have created the form using the vba i.e. UserForm1.

And I have kept one Run command button on the excel sheet.

So when the user click on this command button the Userform should run.

Can anyone help me the coding for the command button? How can I make this?

Please help me.

Thanks a lot.

[MarvinP]

Hi somani,

Find the attached with the most basic VBA I can create to do what I think you want.

You need some VBA command that does a "Userform1.Show". I've added a Userform1 to the workbook and created a Button that when clicked calls the VBA Module code to Show the Userform. See the attached.

[somani123]

It works fine.

Thanks a lot.