Professional Forms in Excel
Instant Access! - Lifetime Access!
45 Tutorials - 5+ Hours of Content - Downloadable Excel Files
Build Professional - Unbreakable - Forms in Excel
These Forms allow you to Input, View, Store, Update, and Delete data in Excel.
Each tutorial comes with a video walk-through and downloadable Excel file.
Original Price $99 >>> Now $49.50 (usd)
SALE ENDS SOON
(50% Discount)
Price: $49.50 (usd)
Course introduction and overview.
Introduction
Formatting
10:35
Formatting the Form
2:28
Consistent Button Formatting
5:11
Different Button Styles
7:14
Hide Entire Excel Interface
2:25
Stop Buttons from Resizing
Validation
28:44
Adding Validation to the Form
6:37
Limit ID Field to a Number (Advanced Methods)
6:22
Require Leading Zeros for an ID
1:55
Data Entry Hints using Input Messages
Macro and Error Display
17:58
Add Error Display and Macro Functionality to the Form
2:06
Custom Error Display
4:05
Name Cells for Easier Macro Reference
3:37
Additional Worksheet References in the Macro
Protect the Form
14:44
Protect the Form
2:52
Hide Data Columns
2:44
Secure Helper Worksheets
2:13
Password Protect the Entire Workbook
Save Form Data
18:41
Save Form Data
16:20
Keep Formatting when Saving Data
3:22
Keep Leading Zeros when Saving Data
13:36
Prevent Duplicate Entries
5:05
Hide and Protect the Data Worksheet
6:33
Password Protect the Data Worksheet
6:35
Use Form Field Range Variables
5:25
Name Form Ranges for Better Macro Use and Readability
View Saved Data Using the Form
23:35
View Saved Data
2:14
Case Sensitive Search
1:55
Partial Match Search
2:49
Return the Last Record - Bottom-to-Top Search
Update Data Using the Form
13:13
Update Data
13:07
Request Update Confirmation
14:04
Require a Password to Update a Record
5:42
Update only Certain Fields from the Form
Delete Data Using the Form
17:03
Delete Data
2:57
Delete Data without Using a Popup Window
2:17
Prevent Title Row Deletion
6:10
Request Delete Confirmation
7:07
Require a Password to Delete a Record
7:28
Reset Form Validation after Deleting Data
Additional Topics
2:13
Add or Remove Password Protection for the Macros and VBA Project
4:56
Better VBA for Clearing the Form
2:13
Clear Form Button
3:43
Ensure ID Values are Stored and Retrieved Correctly
3:31
Remove Auto-Password Protect Option in VBA
1:25
Rename VBA Modules for Better Readability