Auto fit a VBA User form in window screen

Подписаться 271 тыс.

Просмотров 147 тыс.

50% 1

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

Опубликовано:

31 янв 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 96

@Guedex75 5 лет назад

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

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@paulocezardesouzasouza2044 4 года назад

Excelente. Outras dicas muito valiosas. Obrigado

@MohAboAbdo 4 года назад

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

@PKAnExcelExpert 4 года назад

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

@nilsbruhner1983 5 лет назад

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

@PKAnExcelExpert 5 лет назад

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

@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

@chiuchiuism 5 лет назад

very helpful, please keep posting! :)

@PKAnExcelExpert 5 лет назад

Thanks

@deepakrao7550 3 года назад

Thank you exactly what i was looking for

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@benjamingmsousa 3 года назад

This is the best. Thank you.

@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

@dopdopno2007 3 года назад

Thank you so much. Very helpful

@PKAnExcelExpert 3 года назад

Thanks for watching

@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

@sarahbee1115 3 года назад

THANK YOU SOOOOOO MUCH!!!

@PKAnExcelExpert 3 года назад

Most welcome

@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

@cherryca5847 4 года назад

very helpful!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@chiuchiuism 5 лет назад

thank youuuu!!!!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@UJJAL_UD 4 года назад

Wow. Some great info

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@akshaychaudhury1983 4 года назад

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

@matiasromera330 3 года назад

excelente solucion!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@mahammadtuhar2703 6 лет назад

App ka videos acha hai.....

@PKAnExcelExpert 6 лет назад

Thanks

@arumugarajvt5220 4 года назад

Super thank you

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@nikdano 2 года назад

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

@trader.fx1 4 месяца назад

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 .

@abdulsafwan711 4 года назад

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

@recepbas9842 5 лет назад

thanks.

@PKAnExcelExpert 5 лет назад

Thanks for watching

@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..

@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.

@sselmas1 5 лет назад

Please more videos vba excel

@PKAnExcelExpert 5 лет назад

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

@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

@mgpkumar9190 5 лет назад

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

@adhunikschool 5 лет назад

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

@guser8632 4 года назад

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

@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

@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?

@syedkhadeer9407 3 года назад

hi, this code can we use for existing userform?

@chandrasagar 2 года назад

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

@SboNdwandwe 5 лет назад

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

@prosantodas9280 4 года назад

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

@abdullahkromah5628 4 года назад

does it work for MSaccess form?

@hanumantsinghrana9244 6 лет назад

सर जी नमस्कार क्या आप छोटे छोटे साफ्टवेयर बनाकर भेज सकते हैं

@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..

@AnilKumar-tm6fq 3 года назад

Sir jab VBA search button par click karta hoon to data show hone ki bajay MS Excel band ho jata hai

@poeticnight9339 3 года назад

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.