How to Run UserForm without Showing Excel Window

Рет қаралды 107,773

2 жыл бұрын

How to run UserForm without showing Excel application?
In this tutorial, we are going to learn Excel and VBA tips to run the UserForm without showing Excel window. With the help of VBA code, we will hide the Excel window and show only UserForm.
Please visit our website www.thedatalabs.org
thedatalabs.org/run-userform-...
#ShowUserFormOnly #TheDataLabs
How to run UserForm in Full Screen mode in Excel and VBA?
• How to run UserForm in...
Thanks for watching! Please like, share, comment and subscribe.
Have a great day!

Пікірлер: 62

@limitone9564 2 жыл бұрын

I don't think this tutorial is complete... so the user clicks the close button then excel shows up? Does not make sense, it should also close the excel. I was also going to ask... if I'm the coder how do I get back to the developer side if excel closes when we hit the close button.

@thedatalabs 2 жыл бұрын

Thanks for your feedback! With the help of current code, you can come to Excel application and do other works if required. This suits both User and Developer if other works required in same workbook. If you want to close the Excel Application along with Userform then remove the two lines existing VBA code and add four lines of new code in UserForm QueryClose sub procedure. So the new code would be: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Application.DisplayAlert=False Unload Me Thisworkbook.close Save changes:=True Application.DisplayAlert=True End Sub Let me know if you have any questions. Thanks!

@juantoknow 2 жыл бұрын

I have done this last year.. Here is the blue print. Upon opening the file. If there are other file were opened. The system promt the user if he continue to use the file(1. all excel file will be hidden) else user must close other files before opening. On the vba form, I put a command(label) for the developer use. And I put a code on the form/command if the form close ❎ then (2. All other excel file will be shown. Hope it helps guys.

@AttackOnTyler Жыл бұрын

@TheDataLabs this creates a memory leak where the only way to close to application is to end Excel in task manager. Also because the code is being ran from thisworkbook, display alerts = true never fires due to the workbook closing before the code can be called. Also Also, if the user doesn't close the app instance using task manager, when they open a workbook, it will bind to the existing instance in memory which has had its visibility set to false. Emails and zoom calls abound

@hinafathima284 Жыл бұрын

@@thedatalabs hi sir i have some error while closing the userform along with excel application

@dragosmilea9691 6 ай бұрын

@thedatalabs thanks for this answer. I was looking for the same solution. On the same note, if the developer will ever want to open the application to do some work in the excel spreadsheet, can you please advise how this will be possible? Thanks in advance!

@culea0alex 2 жыл бұрын

Holly cow, this works and it's so cool. TY very much.

@querrythis 2 жыл бұрын

Fit me needs perfectly. Thanks

@3pehrs 2 жыл бұрын

it is totally helpful and inspiring 😊 thanks 👍

@ahmedabbas7844 2 жыл бұрын

Thanks for your help 😃☺️

@alioujalan3378 Жыл бұрын

awesome trick

@ynt9011 2 жыл бұрын

I love your video

@sachkum 2 жыл бұрын

These tutorials are very useful. I would like to know how can we create a similar data entry form where multiple users can enter data on a shared drive location simultaneously. Every user should be able to see only his data (that he has entered) on the forms list box & not other users data. Also, if the user wishes to download his data, he gets a link label option to download the data to a new excel file. Please can you create a video for performing this activity.

@balasahebpuri76 Жыл бұрын

बहोत बढिया

@fabioluiz8677 Жыл бұрын

Deixando um like e um abraço

@AjaySharma-em2ez 2 жыл бұрын

Thank you sir, for sharing this great work sir. thank you sir.

@thedatalabs 2 жыл бұрын

Thanks!

@rathaprrathapr5131 Жыл бұрын

very good

@ramgella1205 2 жыл бұрын

Thanks Sir this help me a lot

@ramgella1205 2 жыл бұрын

Sir are you going to download how you create this userform?

@imrandaud478 10 ай бұрын

Wonderful ❤

@thedatalabs 10 ай бұрын

Thanks for your feedback!

@ZiadAdly Жыл бұрын

many thanks

@thedatalabs Жыл бұрын

Thanks for watching and feedback!

@khaledmezghani3701 Жыл бұрын

Thanks for this tutorial :) can we apply this trick on only one specific workbook. i.e. when I try to do what you did in this video, all other open Excel workbooks become invisible. I want a specific workbook to become invisible and the others visible as usual Thanks in advance

@NamHaVblog Жыл бұрын

thanks

@mra893 8 ай бұрын

Nice

@affiliateme7414 Жыл бұрын

is the floating window type of thing possible with google sheets?

@syedshahzaibali4729 2 жыл бұрын

Hello there, I tried this code and its working fine but there is small problem, when I click on the excel file it shows the excel sheet before running the user form.

@daroodurmul5789 Жыл бұрын

excellent job....but how we start user form ...I made a form everything is ok..but when when i clici the excel icont it start with sperad sheet..I want to start the interface of userform at ffirst click..please extend your kind knowledge thanks'

@abdulnasirafridi 2 жыл бұрын

Development video of this inventory nanagement system share please

@Maclan_0709 2 жыл бұрын

Thanks for this greate vba turorial. Do you have a tutorial how to create this form?

@thedatalabs 2 жыл бұрын

This form is from Inventory Management System! We are working on that and we will post an end to end tutorial on that. Please keep watching. Thanks!

@Maclan_0709 2 жыл бұрын

@@thedatalabs It's noted, thanks a lot❤

@saji4385 2 жыл бұрын

@@thedatalabs sir, is this video tutorial already posted. I am waiting to for it

@edtardaguila3599 2 жыл бұрын

the problem with this code is that if you have multiple excel files opened all of them will be hidden. is there a way that the file which the userform resides will be hidden once you run the code?

@likithsreedhar3996 Жыл бұрын

❤

@user-dl1qq3ef3j 9 ай бұрын

dear i disable the visiable on close as well , it works but when i open the file again the ecvel sheet show so i need to close and open again to show the form what is the solution

@jungali_boi Жыл бұрын

can i ask you a question ❓ i learned to run a program without showing excel. i want to learn a program that closes without showing excel again.

@Pankajkumar-yv5dr Жыл бұрын

Is it passible with Google sheets too

@tusharmali4797 2 жыл бұрын

but another excel file invisible when i open this files i hope you understood my qery

@fayzalikhurshed3398 2 жыл бұрын

Hi, I have some questions how I can contact with you?

@samuelasare9387 4 ай бұрын

Thank you for your video tutorials. My problem is that your videos are not clear at all. Please can you research and get to know how you can adjust your camera to ensure clarity of video?

@satishdeshpande1336 2 жыл бұрын

Dear sir.. When the application is hide behind userform.. is it possible to trigger to print specific sheet from button created on userform.. I mean to make PDF for specific sheet....? Waiting you genuine reply...👍

@thedatalabs 2 жыл бұрын

Yes, you can perform all the task as Excel is running in background. Thanks!

@bhavneshparikh8283 2 жыл бұрын

Add in purchase return Sales return

@sallytong241 Жыл бұрын

I tried both solutions but in vain. The application has opened first and close right after, then login form show up.

@mohamadalqalmawy9054 Жыл бұрын

I need the excel file please

@nassimgaming4948 9 ай бұрын

Bro it doesn't need full 12 minute to explain. . Anyway good luck

@karzanq424 7 ай бұрын

Is there any other way bro? Guide me.

@joshitoshi9835 Жыл бұрын

bro will u send excel to exe compiler software at my email?

@sabbirhowlader4325 10 ай бұрын

I am interest

@riteshrsimc 2 жыл бұрын

Customisation is not allowed as it is password protected

@thedatalabs 2 жыл бұрын

thedatalabs

@mosamra3776 6 ай бұрын

yeah but this hides any other excel files that are open.. so it's really useless.. or if the user have excel files open, it will hide everything

@manishsoni125 5 ай бұрын

Not working

@rumeshanjana8167 Жыл бұрын

This is not working

@mstechnical1937 Ай бұрын

1st 5 mint are wasting Time

@michaelgalang9550 Жыл бұрын

2 much cringe in tNice tutorials section xD

@EvilEyeTheEye Жыл бұрын

How do I know my VBA Project Password, I didn't set up any password while I create my Macro VBA but it keeps asking me to enter the VBA Project password. How do I know that password...???

@culea0alex 2 жыл бұрын

Now I just saw your pined comment. Well, you can acces your code by pressing Ctrl+break. And if you want to make so that EXEL won't ask you to save the file, here is the code: Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ThisWorkbook.Saved = True 'Tells Excel that the file has already been saved (this prevents.. '...Excel from requesting that you save the file when you close it) End Sub