Excel VBA and Macros - Chapter 48 - Introducction to UserForms and ActiveX controls

Опубликовано: 14 Октябрь 2024
на канале: Sergio Alejandro Campos - EXCELeINFO
24,269
1.1k

✅ Download the file | http://www.exceleinfo.com/curso-excel...
🏆 Subscribe | https://bit.ly/youtube-tutoriales

Userforms

What are the Forms or User Forms.
How the Forms look.
Steps to create a Form.
Form controls.

What are the Userforms

Forms or dialog boxes are the way in which a user interacts with an application.
Virtually every program in Windows uses Forms and several times they are intuitive for most users.
Developers in Excel use Forms to create interactive files.
In previous chapters we saw the Excel Integrated Dialog Boxes.

ActiveX controls

In each Form we can insert Controls to interact with some procedure.
Each control has properties that can be modified in the Properties window.
It is advisable to modify the properties of each control using VBA code to have total control over the operation of the form.
Form controls can also be inserted in Excel sheets. Programmer tab - Controls - Insert - ActiveX Controls.

More examples | http://www.exceleinfo.com
More examples | http://blogs.itpro.es/exceleinfo
Facebook Page |   / exceleinfo  
Get notificacions on Telegram | https://t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH

Download EXCELeINFO addin:
http://addin.exceleinfo.com

#MsExcel #VBA