How to open and close a userform automatically using Excel VBA

Mike wants to know how to open a userform when he open opens his Excel workbook and how to close the userform once the work is finished.
We quickly design the userform using labels, textboxes and command buttons. Then we code the userform to open automatically and the appropriate button to close the userform once the data entry work is finished.
The macro code and other details are available here:

[sgdingman]

Thank you Mr. Dinesh Kumar Takyar for the suggest link. I watched it and again thank you. I know now much more than I did before this. You are so crystal clear about what you are doing. I'm so happy with the results.

[ANATOMYTAJ]

how you open for second time...bro...you are doing excellent work, ...keep it up

[jaypalsinhzala]

Very useful link you have provided, Finally i have made what i needed through your video.Thanks

[betesguerra]

Hi!
Thank you very much! I'ts working! I learned how to do text box, text label, close/open the file, and VBA command button with this video . You really are a good teacher. Looking forward to see all you VBA and macro videos. Highly recommended to all! More Power!

[bjornar]

Thank you so much Mr. Takyar. This saved my day, and many months of work ahead.

Merry Christmas :)

B

[deancorleone]

You have the best tutorials !!! thank you so much for all the time you have spend making these video's and teaching us!

[Mystarq]

thanks for this video and please send code when i closed userform "X" red ask save, Don't save and cancel like a close excel.

[sgdingman]

Thank you so much. I had never worked with Forms before, but now, I see. Is there an easy way to bring that UserForm back up, I have other selections that I want to have in that form?

[vishalpatil]

Nice video sir...!!!

It's is possible to open userform prompt when, Click on sheet...

[chizobaorizu]

Thank you for this. I am trying to keep that particular form open and at a pinned to the sheet as I toggle from one sheet to another. How can I do that please?

[tiendinh]

Thank you every much excellent teacher online

[kehdi]

Hi, please,  how do I edit on sheets without closing the userform box? I am using MAC 2011. I want to be able to edit on both, without closing the userform box.

[marcelonem]

Thanks!!! I am creating my first VBA file and I was searching this code.

[kailashsoni]

Respected sir

Is there any way when I close user form using x button so workbook should also close with that (which was hidden using application.visible false command)

[theresacabalbag]

Sir ive been watching your videos and it is very helpful. But i was wondring how to do the vba code if one label needs multiple textboxes and combo boxes so that the entries therein will go to the same column and it will not overwrite. Thank u sir😊

[lodyvermeulen]

what is the code in excel vba to go from one form to another form where the first one exits

[mohammadbilal]

Good sir I like ur video but I need some formulas in PDF form where are available and or book form

[meithileshramautar]

Hi sir. This was useful. I need to put a button in my form which will clear all the entries i have made to in the form. I do not want to clear the entries in the database but the entries in the form itself. Kindly advise please

[danielgarciacruz]

Thanks for sharing Dinesh Kumar Takyar ... i have a question for you, how i disable the close (x) button of a userform? ... i have a login user form and i need disable that button... thanks!

[farhanmahmood]

sir,
thank you very much could you please addthis to specify new short key to oepn form... and close form. i mean user form.