Go back to required cell to fill

[erutherford]

Have the basics down, now just trying to make it easier for the end user. Cell C21 is a required cell to be fill, not not a Message pops up. I would like the vba to take them right to that cell.
Here is the code I am using.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Cells(21, 3).Value = "" Then

MsgBox "License No. requires input before print"

Cancel = True

End If

End Sub
​

thanks in advance

 

[My Aswer Is This]

Try this:

I modified Ricks script just a little. Telling the user why we stopped the script:

Private Sub CommandButton1_Click()
  If Cells(21, 3).Value = "" Then
    MsgBox "License No. requires input before print"
    Cells(21, 3).Select
    
    Cancel = True
    MyValue = InputBox("Enter License Plate Info")
    If Len(Trim(MyValue)) Then
      Range("C21").Value = MyValue
    Else
      MsgBox "Hello we told you a License No.  is required" _
      & vbNewLine & "And you failed to enter one." _
      & vbNewLine & "So we are just going to end this script": Exit Sub
    End If
  End If
  
  Range("A1:I50").PrintOut
End Sub

OK

 

[erutherford]

This script will give you a Input Box no matter if Cells(21,3) has a value or does not have a value. So why is the Message Box needed?

That was suggested as a solution to require, that cell to be filled before printing. Now having gone through this exercise, I see your point as well. Looks like it works fine without it and I can just change the text to read " you forgot, bah, bah....

Certainly cleaner, which is always better

 

[My Aswer Is This]

Glad we were able to help you. Come back here to Mr. Excel next time you need additional assistance.

That was suggested as a solution to require, that cell to be filled before printing. Now having gone through this exercise, I see your point as well. Looks like it works fine without it and I can just change the text to read " you forgot, bah, bah....

Certainly cleaner, which is always better