Auto fit a VBA User form in window screen

  Рет қаралды 148,619

PK: An Excel Expert

PK: An Excel Expert

Күн бұрын

Пікірлер: 96
@orhandursun2262
@orhandursun2262 4 жыл бұрын
my teacher thank you so much
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for watching
@orhandursun2262
@orhandursun2262 4 жыл бұрын
@@PKAnExcelExpert Hello, I am living in Turkey. Greetings to you from here, my teacher.
@debbie6085
@debbie6085 3 жыл бұрын
Thank you PK. Lots of useful tips.
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@MohAboAbdo
@MohAboAbdo 4 жыл бұрын
محمد أبو عبدو قبل 35 دقيقة Great video, valuable informations Thank you so much, dear teacher . Thanks.... Thanks.... Thanks....
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@Guedex75
@Guedex75 6 жыл бұрын
Thanks man. this autofit code helped me to finish my project.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@akshaychaudhury1983
@akshaychaudhury1983 5 жыл бұрын
hi, thanks for this tutorial. will you please advise how to center fit the frame in such responsive userform??.
@deepakrao7550
@deepakrao7550 3 жыл бұрын
Thank you exactly what i was looking for
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@xAdamxxxxxx
@xAdamxxxxxx 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
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@TheDuerden
@TheDuerden 4 жыл бұрын
Great video ! very useful information to have for creating a Userform
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@dopdopno2007
@dopdopno2007 4 жыл бұрын
Thank you so much. Very helpful
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for watching
@Infotokev
@Infotokev 6 жыл бұрын
Very nice. Thank you for sharing you knowledge.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@trader.fx1
@trader.fx1 9 ай бұрын
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 .
@nikdano
@nikdano 2 жыл бұрын
Hi dear ! How can I disable X (close) button on WindowState? Thank you so much your great video descriptions👍
@sarahbee1115
@sarahbee1115 3 жыл бұрын
THANK YOU SOOOOOO MUCH!!!
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Most welcome
@harun-or-roshid6287
@harun-or-roshid6287 4 жыл бұрын
How will I define multipage width & height according monitor size ? Please help me to auto fit multipage on userform in window screen .
@jreeeii
@jreeeii 3 жыл бұрын
I have the same problem, uhmm Sir did you found out how to do it? Thanks for your answer in advance.
@benjamingmsousa
@benjamingmsousa 4 жыл бұрын
This is the best. Thank you.
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@bstechnologyrajbiraj1085
@bstechnologyrajbiraj1085 6 жыл бұрын
Very Interesting topic sir thank you very much
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@abdulsafwan711
@abdulsafwan711 4 жыл бұрын
Excellent work ... is that possible to change the colour of userform heading
@nilsbruhner1983
@nilsbruhner1983 5 жыл бұрын
Thank u Sir For Ure Tuts! Very Helpful all of them. //Nils
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@islamandtheworld8928
@islamandtheworld8928 6 жыл бұрын
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
@PKAnExcelExpert 6 жыл бұрын
I will try to make such video very soon.
@islamandtheworld8928
@islamandtheworld8928 6 жыл бұрын
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..
@arumugarajvt5220
@arumugarajvt5220 4 жыл бұрын
Super thank you
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@paulocezardesouza50
@paulocezardesouza50 4 жыл бұрын
Excelente. Outras dicas muito valiosas. Obrigado
@rakeshbond009
@rakeshbond009 5 жыл бұрын
Cool bro. This is very usefull. Cheers
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@UJJAL_UD
@UJJAL_UD 4 жыл бұрын
Wow. Some great info
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@chiuchiuism
@chiuchiuism 5 жыл бұрын
very helpful, please keep posting! :)
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks
@chandrasagar
@chandrasagar 3 жыл бұрын
Hi, is there any option to create template creation for images past in word in the template formate
@mahammadtuhar2703
@mahammadtuhar2703 6 жыл бұрын
App ka videos acha hai.....
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks
@matiasromera330
@matiasromera330 3 жыл бұрын
excelente solucion!
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@ApprendreavecJADDI2023
@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
@syedkhadeer9407 3 жыл бұрын
hi, this code can we use for existing userform?
@bstechnologyrajbiraj1085
@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
@PKAnExcelExpert 6 жыл бұрын
I got your question Binod. I will definitely try to make such video very soon
@JonathanIsmaila
@JonathanIsmaila 6 жыл бұрын
Why bit use a database application + vb.net?
@soulcorraltorres5533
@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
@jonathanpangu3717
@jonathanpangu3717 6 жыл бұрын
Great tips thank you
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@guser8632
@guser8632 5 жыл бұрын
Thanks sir , but in my excel its showing black background while I try to insert module how can make it white plzz?
@cherryca5847
@cherryca5847 5 жыл бұрын
very helpful!
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@MAS..........
@MAS.......... 3 жыл бұрын
Amazing
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@MAS..........
@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
@chiuchiuism
@chiuchiuism 5 жыл бұрын
thank youuuu!!!!
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@sselmas1
@sselmas1 6 жыл бұрын
Please more videos vba excel
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Sure. I will be watching new videos on VBA very soon
@creativezonedimplechauhan4730
@creativezonedimplechauhan4730 6 жыл бұрын
hi can we auto fit of selected active chart??
@prosantodas9280
@prosantodas9280 5 жыл бұрын
Need userform on userform, like, userform with comandbutton then click on it then another userform data entry pls hlp
@mgpkumar9190
@mgpkumar9190 6 жыл бұрын
Sir Could you create a treeview project from data in excel sheet ?
@adhunikschool
@adhunikschool 5 жыл бұрын
Sir how to format a column for force entery of date as DD-MM-YYYY
@abdullahkromah5628
@abdullahkromah5628 4 жыл бұрын
does it work for MSaccess form?
@recepbas9842
@recepbas9842 5 жыл бұрын
thanks.
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for watching
@boudaoudnazim2694
@boudaoudnazim2694 Жыл бұрын
it doesn't work for me, the value of the button gives me false on click, can you help me
@salmanshaikh7056
@salmanshaikh7056 4 жыл бұрын
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
@SboNdwandwe
@SboNdwandwe 6 жыл бұрын
The content is good but God those ads, after every minute an ad interferes.
@poeticnight9339
@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.
@AnilKumar-tm6fq
@AnilKumar-tm6fq 3 жыл бұрын
Sir jab VBA search button par click karta hoon to data show hone ki bajay MS Excel band ho jata hai
@hanumantsinghrana9244
@hanumantsinghrana9244 6 жыл бұрын
सर जी नमस्कार क्या आप छोटे छोटे साफ्टवेयर बनाकर भेज सकते हैं
@mitulpatelful
@mitulpatelful 4 жыл бұрын
plz send excel file
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Please download it from the link given in video's description box
@juliuslaurella2816
@juliuslaurella2816 6 жыл бұрын
nice sir..please send me code..thanks
@PKAnExcelExpert
@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
@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..
@Inahuin
@Inahuin 5 жыл бұрын
Codingnya mana Boss....?
@manishrawal1529
@manishrawal1529 4 жыл бұрын
Not working
@sarveshcarsss8917
@sarveshcarsss8917 5 жыл бұрын
Time kam lo
@venomad77
@venomad77 6 жыл бұрын
Too many damn commercials and banners in your video bro. Unwatchable.
@suatomerbeyoglu3180
@suatomerbeyoglu3180 4 жыл бұрын
thanks for the useful information
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
Timer in Excel VBA
12:59
PK: An Excel Expert
Рет қаралды 100 М.
Automatically Hide Workbook in Background and View only User Form
12:30
Dinesh Kumar Takyar
Рет қаралды 146 М.
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 661 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 26 МЛН
Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
17:59
PK: An Excel Expert
Рет қаралды 542 М.
How to Easily Create an Data Entry Form in Excel | No VBA
22:30
Jopa Excel
Рет қаралды 52 М.
How to create User Login Form in VBA and Excel (Step by Step Guide)
23:02
I am Surprised: Maximize User form With All Control Auto Fit
15:48
VBA User Form: Add, Update, Delete and Save
22:47
hay kel
Рет қаралды 65 М.
How to run UserForm in Full Screen Mode in Excel and VBA
11:00
TheDataLabs
Рет қаралды 39 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 923 М.