Thanks! Thanks for watching and have a nice day.

My pleasure. If you're interested in learning more about VBA, you can explore additional videos in this playlist: kzfaq.info/sun/PLiuWj5f7bcs-HAIceO3mdYXnJ5iQQOHLv. I hope you find them helpful. Thanks for watching and have a nice day.

My pleasure. Thanks for watching. Have a nice day.

Thanks! Thanks for watching and have a nice day.

My pleasure. Thanks for watching and have a nice day.

My pleasure. Thanks for watching. Have a nice day.

My pleasure. Thanks for watching and have a nice day.

mon plaisir. Merci d'avoir regardé et bonne journée.

My pleasure. Thanks for watching. Have a nice day.

My pleasure. Thanks for watching and have a nice day.

My pleasure. Thanks for watching. Have a nice day.

My pleasure. Thanks for watching and have a nice day.

Mi placer. Gracias por ver. Deseando que tengas un buen día.

My pleasure. Thanks for watching and have a nice day.

My pleasure. Thanks for watching and have a nice day.

My pleasure. Thanks for watching. Have a nice day ^^

My pleasure. Thanks for watching and have a nice day.

Thanks bro. Have a nice day.

Hi Rudra. For your question, I'm going to remove the existing title (menu) bar and insert/customize a title bar either by using label(s) or image(s) and link to another UserForm with those options. Currently, I only have tutorial on changing the color of title bar by using label at kzfaq.info/get/bejne/b66PjbilmrbFdIE.html (not sure if it helps), and I'm working on a video on inserting images on UserForm (will be uploaded soonest possible). Thanks for watching and have a nice day.

thanks for your reply and i waiting for your new video...

Rudra, really sorry that I reply this late. Not sure if you still looking for it since it was 4 days ago. Insert image control and add picture on UserForm as well as calling a sub on muse click by using image control 👉 kzfaq.info/get/bejne/hLtja7Kiv7DRXYE.html But then, after some considerations, I feel that the video is less relevant for your case. A better way is to change the default usage of the close button. I would like to make an apology again since I don't have a step-by-step tutorial on changing the default usage of the close button. However, I have created a template for you at facebook.com/groups/486402069483674/permalink/696837981773414 and the file password is AhSingClose. I scared it will take me a few days to get the video ready to be uploaded, so I decided to share the template with you first. Hope it helps and have a nice day.

Thank you very much sir, you are such a genius person

My pleasure. I'm glad it helps. 😃

My pleasure. With regard to your inquiry, you can get it done by changing the procedure in the particular UserForm. Hope it helps. Thanks for watching and have a nice day.

@@ahsingtv Thanks for your reply. I want to make a program of keyboard display. For that purpose I made an inquiry. Anyways, thanks a lot.

No problem. My pleasure. Have a nice day.

Hi Randy. Yup. You may add Private Sub Worksheet_SelectionChange(ByVal Target As Range) Unload UserForm1 End Sub to the VB of that particular sheet. Do remember to set the ShowModal under the properties window of the Userform to "False". May refer to kzfaq.info/get/bejne/gZh-d710r5zdiJs.html, time: 0:28 Hope it helps. Thanks for watching. Have a nice day.

Hi Addie. I found a useful website wellsr.com/vba/2017/excel/beautiful-vba-progress-bar-with-step-by-step-instructions/ by Ryan Wells. Have a nice day.

Hi there. Double click the ComboBox, then change the procedure to "Enter". The syntax is as follow. With Sheet1.ComboBox1 .AddItem "Option 1" .AddItem "Option 2" End With Hope it helps. Thanks for watching and have a nice day.

@@ahsingtv Thanks for you responding can i attach my userform with mail address fix it please

Hi. Do you mean you only want to attach the UserForm in your email? You can right click the "UserForm" under the Project then click on "Export". Or you wish to put your email address on the UserForm? This can be done by inserting label. I'm not sure is that the question you were looking for. However, I hope it helps. Have a nice day.

@@ahsingtv how can i filter listbox data with combobox and command click ony

Hi. You may try this, Review -> Protect Workbook -> Protect workbook for -> Windows. Hope it helps. Thanks for watching and have a nice day.

Hi. If the close button was removed, we must have a code (Unload Me) to tell the Excel to close the UserForm. If you don't want to insert a command button on the UserForm, you may try the alternative ways: (i) go to Visual Basic then double click on the UserForm and you will see "Private Sub UserForm_Click()", write the code "Unload Me". (ii) insert a command button (or any relevant controls) on worksheet then insert the code "Unload UserForm#". *# represents the numbering of the respective UserForm. For this method, we have to make sure the "Show Modal" of the UserForm is set to "False". I'm not sure if this help. Please let me know if you need any further assistance.

Hi. If you can't access to visual basic because of that, you may try these methods kzfaq.info/get/bejne/Zp6IdKqXqdSvfnk.html Hope this help you.

Better solution available at kzfaq.info/get/bejne/ouCRi9CDrM-taaM.html Thanks for watching and have a nice day.

Bro, may I know what do you mean by "software file"?

1 sales order 2. Production. 3 production status check all companies one software Totally production updates software

Quite difficult for me to imagine. To let an excel spreadsheet to function, I have to know type of input and what kind of output. If you wish to auto run a macro when a particular file is opened, I would suggest you to watch this kzfaq.info/get/bejne/nqmlpsyEz7rRk3k.html.