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
Негізгі бет Тәжірибелік нұсқаулар және стиль Excel VBA: Using the MultiPage Control in your Userforms
Пікірлер: 26