Excel VBA: Using the MultiPage Control in your Userforms

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ก.ค. 2024
  • In this video, we demonstrate how to use the MultiPage control in Excel VBA userforms.
    Take the Excel VBA for beginners course - bit.ly/2JvnnRv
    This control can be very useful when you have a lot of controls to fit onto a userform, or just would like to organise them better for easier access.
    In this example, I have a list of customers. The userform contains two pages. One page for editing customer details and another page for common tasks.
    The MultiPage control make it simple to group these control on separate pages.
    The video will show you how to create a userform with multiple pages, modify properties of the MultiPage control and then refer to the control and its pages within VBA during the macro.
    Find more great free tutorials at;
    www.computergaga.com
    ** Online Excel Courses **
    Excel VBA for Beginners ► bit.ly/2JvnnRv
    Advanced Excel Tricks ► bit.ly/3CGCm3M
    Excel Formulas Made Easy ► bit.ly/2t3netw
    The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
    Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
    Connect with us!
    LinkedIn ► / 18737946
    Instagram ► / computergaga1
    Twitter ► / computergaga1
  • แนวปฏิบัติและการใช้ชีวิต

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

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

    Great video! Thanks, Alan!

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

    Thanks mate, really helpful

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

    Wonderful. Thanks for sharing

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

    Very good video. Congratulations!!

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

    Thank you very much, VBA guru.

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

    Excellent video again... I would like to watch more videos on VBA.

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

      Thanks. I will keep them coming.

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

      @Josette Hosendove On VBA?

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

    thank you it's awesome

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

    Great lesson

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

    Thanks
    Very Good tutorial

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

    please do a tutorial on creating students database..thank you

  • @AbCd-kh5if
    @AbCd-kh5if ปีที่แล้ว

    How to create Search butto on multipage

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

    Very great, Can you share ? Thks

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

    Hello can you please provide the code to search by ID ? In the minute 12:59 it if show but not complete

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

    can i change the ID to phone number ? if yes how can i do that ? thank you very much.

  • @amyroamyro8344
    @amyroamyro8344 10 หลายเดือนก่อน

    my id is 1133 but my fullname and city is wrong !! jeje