For example, if you want the event to run when the user selects cell B9, change this code to:If Not Intersect (Range ("B9"), Target) Is Nothing Then End If Insert code for your event within the If ...

With that control selected, enter ClassTable as the new control’s Row Source property, as shown in Figure I. Figure I Set the control’s Row Source property. Press [F5] to run the UserForm.