Darryl,
I use this to pop up a calendar. Format the cells according to the script that you want to click on to open the calendar.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.NumberFormat = "m/d/yy;@" Then
If CalendarFrm.HelpLabel.Caption <> "" Then
CalendarFrm.Height = 191 + CalendarFrm.HelpLabel.Height
Else
CalendarFrm.Height = 191
CalendarFrm.Show
End If
End Sub
you will have to adapt it to your script but it shows how you can format specific cells so that when they are clicked, it will call your form. Hope this helps. It is a custom format. m/d/yy;@
ps. the vba goes in the code for the sheet