Auto fit a VBA User form in window screen

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ต.ค. 2024

ความคิดเห็น • 96

  • @debbie6085
    @debbie6085 3 ปีที่แล้ว +2

    Thank you PK. Lots of useful tips.

  • @orhandursun2262
    @orhandursun2262 4 ปีที่แล้ว +1

    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.

  • @sarahbee1115
    @sarahbee1115 3 ปีที่แล้ว +1

    THANK YOU SOOOOOO MUCH!!!

  • @MohAboAbdo
    @MohAboAbdo 4 ปีที่แล้ว +1

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

  • @deepakrao7550
    @deepakrao7550 3 ปีที่แล้ว +1

    Thank you exactly what i was looking for

  • @dopdopno2007
    @dopdopno2007 3 ปีที่แล้ว +1

    Thank you so much. Very helpful

  • @Guedex75
    @Guedex75 6 ปีที่แล้ว +3

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

  • @TheDuerden
    @TheDuerden 4 ปีที่แล้ว +1

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

  • @xAdamxxxxxx
    @xAdamxxxxxx 6 ปีที่แล้ว +1

    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

  • @suatomerbeyoglu3180
    @suatomerbeyoglu3180 4 ปีที่แล้ว +1

    thanks for the useful information

  • @nikdano
    @nikdano 2 ปีที่แล้ว

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

  • @benjamingmsousa
    @benjamingmsousa 4 ปีที่แล้ว +1

    This is the best. Thank you.

  • @matiasromera330
    @matiasromera330 3 ปีที่แล้ว +1

    excelente solucion!

  • @arumugarajvt5220
    @arumugarajvt5220 4 ปีที่แล้ว +1

    Super thank you

  • @Infotokev
    @Infotokev 6 ปีที่แล้ว +1

    Very nice. Thank you for sharing you knowledge.

  • @islamandtheworld8928
    @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
      @PKAnExcelExpert  5 ปีที่แล้ว

      I will try to make such video very soon.

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

  • @trader.fx1
    @trader.fx1 8 หลายเดือนก่อน

    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 .

  • @rakeshbond009
    @rakeshbond009 5 ปีที่แล้ว +1

    Cool bro. This is very usefull. Cheers

  • @UJJAL_UD
    @UJJAL_UD 4 ปีที่แล้ว +1

    Wow. Some great info

  • @paulocezardesouzasouza2044
    @paulocezardesouzasouza2044 4 ปีที่แล้ว

    Excelente. Outras dicas muito valiosas. Obrigado

  • @chiuchiuism
    @chiuchiuism 5 ปีที่แล้ว +1

    very helpful, please keep posting! :)

  • @chiuchiuism
    @chiuchiuism 5 ปีที่แล้ว +1

    thank youuuu!!!!

  • @nilsbruhner1983
    @nilsbruhner1983 5 ปีที่แล้ว +1

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

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

  • @MAS..........
    @MAS.......... 3 ปีที่แล้ว +1

    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

  • @akshaychaudhury1983
    @akshaychaudhury1983 5 ปีที่แล้ว +2

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

  • @syedkhadeer9407
    @syedkhadeer9407 3 ปีที่แล้ว

    hi,
    this code can we use for existing userform?

  • @harun-or-roshid6287
    @harun-or-roshid6287 4 ปีที่แล้ว +1

    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.

  • @mahammadtuhar2703
    @mahammadtuhar2703 6 ปีที่แล้ว

    App ka videos acha hai.....

  • @cherryca5847
    @cherryca5847 5 ปีที่แล้ว +1

    very helpful!

  • @chandrasagar
    @chandrasagar 2 ปีที่แล้ว

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

  • @recepbas9842
    @recepbas9842 5 ปีที่แล้ว +1

    thanks.

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

  • @abdullahkromah5628
    @abdullahkromah5628 4 ปีที่แล้ว

    does it work for MSaccess form?

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

  • @sselmas1
    @sselmas1 6 ปีที่แล้ว +1

    Please more videos vba excel

    • @PKAnExcelExpert
      @PKAnExcelExpert  6 ปีที่แล้ว

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

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

  • @creativezonedimplechauhan4730
    @creativezonedimplechauhan4730 6 ปีที่แล้ว

    hi can we auto fit of selected active chart??

  • @bstechnologyrajbiraj1085
    @bstechnologyrajbiraj1085 6 ปีที่แล้ว +1

    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 ปีที่แล้ว +1

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

    • @JonathanIsmaila
      @JonathanIsmaila 5 ปีที่แล้ว +1

      Why bit use a database application + vb.net?

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

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

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

  • @prosantodas9280
    @prosantodas9280 5 ปีที่แล้ว

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

  • @mgpkumar9190
    @mgpkumar9190 5 ปีที่แล้ว

    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

  • @hanumantsinghrana9244
    @hanumantsinghrana9244 6 ปีที่แล้ว

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

  • @SboNdwandwe
    @SboNdwandwe 6 ปีที่แล้ว

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

  • @mitulpatelful
    @mitulpatelful 4 ปีที่แล้ว +1

    plz send excel file

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 ปีที่แล้ว +1

      Please download it from the link given in video's description box

  • @manishrawal1529
    @manishrawal1529 4 ปีที่แล้ว

    Not working

  • @Inahuin
    @Inahuin 5 ปีที่แล้ว

    Codingnya mana Boss....?

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

  • @sarveshcarsss8917
    @sarveshcarsss8917 5 ปีที่แล้ว

    Time kam lo

  • @venomad77
    @venomad77 6 ปีที่แล้ว +1

    Too many damn commercials and banners in your video bro. Unwatchable.

  • @jonathanpangu3717
    @jonathanpangu3717 6 ปีที่แล้ว

    Great tips thank you