Auto fit a VBA User form in window screen

Рет қаралды 147,095

6 жыл бұрын

Hello Friends,
In this video you will learn how to auto fit a VBA user form in window screen.
Please download this excel file from below given link:
drive.google.com/open?id=1lej...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Send me your queries on telegram:
@PKanExcelExpert

Пікірлер: 96

@paulocezardesouzasouza2044 4 жыл бұрын

Excelente. Outras dicas muito valiosas. Obrigado

@Guedex75 5 жыл бұрын

Thanks man. this autofit code helped me to finish my project.

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@Infotokev 6 жыл бұрын

Very nice. Thank you for sharing you knowledge.

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@debbie6085 3 жыл бұрын

Thank you PK. Lots of useful tips.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@bstechnologyrajbiraj1085 6 жыл бұрын

Very Interesting topic sir thank you very much

@PKAnExcelExpert 6 жыл бұрын

Thanks for watching and sharing your valuable feedback

@benjamingmsousa 3 жыл бұрын

This is the best. Thank you.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@deepakrao7550 3 жыл бұрын

Thank you exactly what i was looking for

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@TheDuerden 3 жыл бұрын

Great video ! very useful information to have for creating a Userform

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@dopdopno2007 3 жыл бұрын

Thank you so much. Very helpful

@PKAnExcelExpert 3 жыл бұрын

Thanks for watching

@nilsbruhner1983 5 жыл бұрын

Thank u Sir For Ure Tuts! Very Helpful all of them. //Nils

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@1V4N- 6 жыл бұрын

Hi, greetings and thanks for the excellent tutorials I swallow with full sighs! Tutorials are a great inspiration to make things better. However, I do not care if the other lessons are not linked to the best tutorial "Data Entry Form in VBA" - three lessons. E.g. the example "auto fit and VBA userform in Window screen" could be optimally linked and given as the next "Data Entry Form in VBA" as well as other lessons. Take this as an idea, not a reproach. Just so, and thank you so much from the Czech Republic

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@jonathanpangu3717 6 жыл бұрын

Great tips thank you

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback

@suatomerbeyoglu3180 4 жыл бұрын

thanks for the useful information

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@chiuchiuism 5 жыл бұрын

very helpful, please keep posting! :)

@PKAnExcelExpert 5 жыл бұрын

Thanks

@cherryca5847 4 жыл бұрын

very helpful!

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@sarahbee1115 3 жыл бұрын

THANK YOU SOOOOOO MUCH!!!

@PKAnExcelExpert 3 жыл бұрын

Most welcome

@akshaychaudhury1983 4 жыл бұрын

hi, thanks for this tutorial. will you please advise how to center fit the frame in such responsive userform??.

@MohAboAbdo 4 жыл бұрын

محمد أبو عبدو قبل 35 دقيقة Great video, valuable informations Thank you so much, dear teacher . Thanks.... Thanks.... Thanks....

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@UJJAL_UD 4 жыл бұрын

Wow. Some great info

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@chiuchiuism 5 жыл бұрын

thank youuuu!!!!

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@matiasromera330 3 жыл бұрын

excelente solucion!

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@orhandursun2262 3 жыл бұрын

my teacher thank you so much

@PKAnExcelExpert 3 жыл бұрын

Thanks for watching

@orhandursun2262 3 жыл бұрын

@@PKAnExcelExpert Hello, I am living in Turkey. Greetings to you from here, my teacher.

@rakeshbond009 5 жыл бұрын

Cool bro. This is very usefull. Cheers

@PKAnExcelExpert 5 жыл бұрын

Thanks for your valuable feedback

@arumugarajvt5220 4 жыл бұрын

Super thank you

@PKAnExcelExpert 4 жыл бұрын

Thanks for your valuable feedback

@mahammadtuhar2703 6 жыл бұрын

App ka videos acha hai.....

@PKAnExcelExpert 6 жыл бұрын

Thanks

@nikdano 2 жыл бұрын

Hi dear ! How can I disable X (close) button on WindowState? Thank you so much your great video descriptions👍

@recepbas9842 5 жыл бұрын

thanks.

@PKAnExcelExpert 5 жыл бұрын

Thanks for watching

@abdulsafwan711 4 жыл бұрын

Excellent work ... is that possible to change the colour of userform heading

@trader.fx1 5 ай бұрын

greetings and respect. Thanks for your great tutorials. I used this code, but considering that my Windows is 64-bit, it gives an error that the code must be updated (performance error). The code can be modified to automatically detect whether Windows is 32 or 64 .

@MAS.......... 3 жыл бұрын

Amazing

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@MAS.......... 3 жыл бұрын

Hi sir Can you please tell me how we can add tables in user Form as we can do in Java and python, Is it possible to do in excel user Form

@islamandtheworld8928 5 жыл бұрын

Hello.Sir... I am very much thankful to you that you solved more than 50 problems in my vba.. Sir, I tried very much to use a code but i am still unsuccessful... that I have created an excel worksheet in which I have used rounded rectangle instead of commond buttons. Now I need your help that when ever mouse will move over it, it should change the back color like as other applications... so help me and send the code. Regards.

@PKAnExcelExpert 5 жыл бұрын

I will try to make such video very soon.

@islamandtheworld8928 5 жыл бұрын

Thank you Sir... if its possible to send a code for a such function. Its my e-mail id: abuuzairlayak@gmail.com thanks a lot.. and I will wait for your vedio..

@sselmas1 6 жыл бұрын

Please more videos vba excel

@PKAnExcelExpert 6 жыл бұрын

Sure. I will be watching new videos on VBA very soon

@guser8632 4 жыл бұрын

Thanks sir , but in my excel its showing black background while I try to insert module how can make it white plzz?

@adhunikschool 5 жыл бұрын

Sir how to format a column for force entery of date as DD-MM-YYYY

@mgpkumar9190 5 жыл бұрын

Sir Could you create a treeview project from data in excel sheet ?

@creativezonedimplechauhan4730 6 жыл бұрын

hi can we auto fit of selected active chart??

@soulcorraltorres5533 3 жыл бұрын

Hi, my user form is meant to be use by various users. And this code works perfectly for me, but when other users have access to it, it does not work, it does not cover the hole screen. And a picture I have on the top of the form is cut. Can you please help me, what could be the issue

@syedkhadeer9407 3 жыл бұрын

hi, this code can we use for existing userform?

@harun-or-roshid6287 3 жыл бұрын

How will I define multipage width & height according monitor size ? Please help me to auto fit multipage on userform in window screen .

@jreeeii 3 жыл бұрын

I have the same problem, uhmm Sir did you found out how to do it? Thanks for your answer in advance.

@prosantodas9280 5 жыл бұрын

Need userform on userform, like, userform with comandbutton then click on it then another userform data entry pls hlp

@chandrasagar 2 жыл бұрын

Hi, is there any option to create template creation for images past in word in the template formate

@bstechnologyrajbiraj1085 6 жыл бұрын

I have one excel question create invoice bill in excel links to stock maintain sheet and automatic add at sales column data

@PKAnExcelExpert 6 жыл бұрын

I got your question Binod. I will definitely try to make such video very soon

@JonathanIsmaila 5 жыл бұрын

Why bit use a database application + vb.net?

@ApprendreavecJADDI2023 Жыл бұрын

How to add and open hyperlink in ListView in VBA EXCEL ??? Can you help me with your sample code, video clip, or training course to solve this problem?

@abdullahkromah5628 4 жыл бұрын

does it work for MSaccess form?

@SboNdwandwe 5 жыл бұрын

The content is good but God those ads, after every minute an ad interferes.

@salmanshaikh7056 3 жыл бұрын

it's not working for me don't know why code is running without any error but my form is opening in very small view

@boudaoudnazim2694 Жыл бұрын

it doesn't work for me, the value of the button gives me false on click, can you help me

@juliuslaurella2816 6 жыл бұрын

nice sir..please send me code..thanks

@PKAnExcelExpert 6 жыл бұрын

Thanks for your valuable feedback. Excel download link has been given in videos discretion box. Please download this excel file from there

@juliuslaurella2816 6 жыл бұрын

Thank you sir..could you please help me with my new project..I am A teacher in the philippines..I want my Excel to view full screen in esc is disabled...it run like an application..

@poeticnight9339 4 жыл бұрын

Can U pls show us how to print User form fit with A4 size paper . I actually can able to save the user form as PDF by using command button but problem is here that user form not fit with PDF file & it always being smaller. So during print have lots of blank area right side & bottom side. Will grateful if u able to fix the issue. Thanks & expecting ur feedback.