CCM

How to create UserForm: in Excel, VBA

Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...
CCM

How to create a cascading combo box: Excel, VBA

How to manage names under Excel? To define names in an Excel Workbook, you can either: For Excel 2007 or earlier version: Insert > Names > Define. Most current versions (from Excel 2010): Ribbon ...
TechRepublic

How to add a UserForm to aid data entry in Excel

How to add a UserForm to aid data entry in Excel Your email has been sent When you need a user-friendly data input process, create an Excel UserForm. Users who are unfamiliar with Excel will find ...
TechRepublic

Pro tip: Populate an Excel UserForm combo box without VBA

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.
Geeky Gadgets

Create Amazing Excel Forms That Look Like Professional Apps

Designing visually appealing and functional Excel forms and interfaces more accessible than you might think. By integrating Excel’s robust features with PowerPoint’s “Merge Shapes” tool and the power ...
Ars Technica

Reset VBA Userform

Hello,<BR><BR>I've got a small question about userforms:<BR>When a userform loads it has certain default values (determined by the develop environement). Nou I am writing an option to reset the ...