Excel VBA - How to create UserForm and disable close button?

Suitable for beginners.

Important syntax:
1. To call UserForm:
UserForm1.Show

2. To close UserForm:
Unload Me

3. To disable the close button:
If CloseMode = vbFormControlMenu Then
Cancel = True
End If

For:

[ahsingtv]

Hope you like it. Thanks for watching and have a nice day.

[shaileshroy]

Thank you so much sir successfully i made first time vba program fo my company

[petralabui]

thanks bro, i'm new in VBA your video just save my work 🙏

[nileshtikekar]

Thank you very much Sir. Sir can u tell the vba code for keypress event in any program but can be visible in excel userform.

[Mystarq]

Thank you very much for this video. How to UserForm close "X" button ask Save, Don't Save, Cancel like excel ?

[randympls]

Is there a way to close the userform by simply clicking outside of the userform, without click on a command button or the red x?

[henokayele]

hello thanks a lot! how can i filter list box data with combobox?

[cseeralan]

How to Create event to avoid maximize or minimize this workbook?

[addiethrasher]

any idea how to remove close button from appear in userform?

[rashonix]

I didnt put the unload me but i removed the close button and i cant get out of my userform... Please Help

[krishnajagadeesh]

Bro make one software file module in excel