This book explains how to create and program userforms in Microsoft Excel. The book is aimed at Microsoft Office users, with some basic knowledge of Visual Basic for Applications (VBA), who want to get the most out of userforms. The book covers from basic concepts to more advanced userform programming techniques. See the list of contents below. The book comes along a very helpful appendix with the list and description of properties, methods, and events of the UserForm and its controls.
Get it now for just $9.99
Delivery may take a few hours or land in your spam folder. Contact me if any issues: xlsgsdata@gmail.com
List of contents:
About
1 Introduction
1.1 Userform vs message and input boxes
1.2 Userform components
1.3 Showing a userform
2 UserForm Object
2.1 Userform module
2.2 UserForm properties
2.3 UserForm methods
2.4 UserForm events
3 Form Controls
3.1 Controls collection
3.2 Control object
3.3 Label
3.4 TextBox
3.5 ComboBox
3.6 ListBox
3.7 CommandButton
3.8 CheckBox
3.9 OptionButton
3.10 ToggleButton
3.11 Frame
3.12 TabStrip
3.13 MultiPage
3.14 ScrollBar
3.15 SpinButton
3.16 Image
3.17 RefEdit
4 Programming Userforms
4.1 Design the form
4.2 Add event procedures
4.3 Add other procedures
4.4 Call a macro from different controls
4.5 Add events to multiple controls
4.6 Perform actions for multiple controls
5 Add Controls Programmatically
5.1 Add a single control
5.2 Add multiple controls
5.3 Resize userform (and controls)
5.4 Add and resize scroll bars
5.5 Add events to run-time controls
6 Specific Use Cases
6.1 Show table on form
6.2 Show chart on form
6.3 Add button hover effect
6.4 Move controls around the form
6.5 Add icons to controls
6.6 Add custom icons
6.7 Create a progress indicator
6.8 Form without title bar
6.9 Transparent userform
7 Practical Examples
7.1 Mortgage Calculator
7.2 Service-Desk Manager
7.3 Forex Tester
7.4 Standalone Calculator
7.5 Other examples
APPENDIX
Other Information:
Presentation: eBook (digital copy)
Format: PDF
Size: 6,167 KB
Created by (author): Excel Macro Mania
Created in (year): 2025
Number of pages: 201
Language: English
No comments:
Post a Comment