I can open the following userform but that's about it. I would like for the code to capture the selection, close the userform and continue to excecute after you select one of the boxes.
VBA Code:
Option Explicit
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Dim ws As String
Dim row As Long
Dim column As Long
Dim UPDATE As String
ws = ActiveSheet.Name
column = ActiveCell.column
row = ActiveCell.row
UserForm2.Show
If column = 6 Then
If CheckBox1.Value = True Then
ElseIf CheckBox2.Value = True Then
ElseIf CheckBox3.Value = True Then
ElseIf CheckBox4.Value = True Then
ElseIf CheckBox5.Value = True Then
ElseIf CheckBox6.Value = True Then
ElseIf CheckBox7.Value = True Then
ElseIf CheckBox8.Value = True Then
End If
end if
End Sub
