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 - แนวปฏิบัติและการใช้ชีวิต
Great video! Thanks, Alan!
You're welcome Sandy.
Thanks mate, really helpful
Thank you Furkan.
Wonderful. Thanks for sharing
You're welcome Syed.
Very good video. Congratulations!!
Thank you Marco.
Thank you very much, VBA guru.
My pleasure, Mark.
Excellent video again... I would like to watch more videos on VBA.
Thanks. I will keep them coming.
@Josette Hosendove On VBA?
thank you it's awesome
Thank you Ismail.
Great lesson
Thank you.
Thanks
Very Good tutorial
Thank you very much.
please do a tutorial on creating students database..thank you
How to create Search butto on multipage
Very great, Can you share ? Thks
Hello can you please provide the code to search by ID ? In the minute 12:59 it if show but not complete
can i change the ID to phone number ? if yes how can i do that ? thank you very much.
my id is 1133 but my fullname and city is wrong !! jeje