Excel 2019 Bible

xxxvii

Contents

Debugging Custom Functions .............................................................................. 958

Inserting Custom Functions ................................................................................ 958

Learning More ................................................................................................... 960

Chapter 44: Creating UserForms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  961

Understanding Why to Create UserForms .............................................................. 961

Exploring UserForm Alternatives ......................................................................... 962

Using the InputBox function ...................................................................... 962

Using the MsgBox function ........................................................................ 963

Creating UserForms: An Overview ........................................................................ 966

Working with UserForms ............................................................................ 967

Adding controls ......................................................................................... 968

Changing the properties of a control ........................................................... 969

Handling events ........................................................................................ 970

Displaying a UserForm ............................................................................... 970

Looking at a UserForm Example ........................................................................... 971

Creating the UserForm ............................................................................... 971

Testing the UserForm ................................................................................. 972

Creating an event handler procedure ........................................................... 973

Looking at Another UserForm Example ................................................................ 974

Creating the UserForm ............................................................................... 974

Creating event handler procedures .............................................................. 976

Showing the UserForm ............................................................................... 978

Testing the UserForm ................................................................................. 978

Making the macro available from a worksheet button ................................... 979

Making the macro available on your Quick Access toolbar ............................ 979

Enhancing UserForms ......................................................................................... 980

Adding accelerator keys ............................................................................. 980

Controlling tab order ................................................................................. 980

Learning More ................................................................................................... 981

Chapter 45: Using UserForm Controls in a Worksheet. . . . . . . . . . . . . . . . . . . . . . . . . .  983

Understanding Why to Use Controls on a Worksheet ............................................. 983

Using Controls ................................................................................................... 986

Adding a control ....................................................................................... 986

Learning about Design mode ...................................................................... 986

Adjusting properties .................................................................................. 987

Using common properties ........................................................................... 988

Linking controls to cells ............................................................................ 989

Creating macros for controls ....................................................................... 989

Reviewing the Available ActiveX Controls ............................................................ 991

CheckBox .................................................................................................. 991

ComboBox ................................................................................................. 991

CommandButton ........................................................................................ 992

Image ....................................................................................................... 992