VBA - User form call in excel button

[nitinsharma_16]

Hi Team,

I made a user form macro. It is successfully run in vba by pressing F5.

I want a button in excel sheet, so that user can click on button and my User form will call.

thanks,

Nitin

 

[RoryA]

Assuming a form called Userform1, the basic code is:

Dim fm as Userform1
set fm = New Userform1
fm.show

 

[nitinsharma_16]

How do I mapped it to excel home page in a button, so that if someone click. Macros screen will come

 

[RoryA]

Just add a Form button and assign a macro that includes that code.

 

[nitinsharma_16]

Error message is showing,

Cannot run the Macros "GTM projects et...". The macros may not be available in this workbook or all macros may be disabled

 

[RoryA]

Are macros enabled?

 

[nitinsharma_16]

Yes

 

[RoryA]

How did you assign the macro, what did you actually assign, what does the full macro code look like, and which module is it located in?