Good afternoon, extreme beginner with VBA.
I debated whether or not to upload a sample workbook as per the rules as I think this is rather simple.
I have a Checklist, consisting of several check boxes, when one of these in particular is ticked, a message box pops up asking the user to confirm the information required, however if the user clicks 'Cancel' the box will still tick as if the information was inputted.
Is there a way to stop it from tickiing upon a user pressing cancel?
the basic code is as follows:
Formula:
Private Sub CheckBox62_Click()
Range("G23").Value = _
InputBox("Please confirm the S/O line(s) of which the contact name & number appear", "Contact Confirmation", Line)
Bookmarks