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

 

[Rick Rothstein]

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"
Cells(21, 3).Select

Cancel = True

End If

End Sub
​

thanks in advance

Add the red highlighted code line shown above.

 

[erutherford]

Thanks for the reply. Since I am very new to vba, so not sure what to suggest

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

MsgBox "License No. requires input before print"
Cells(21, 3).Select
Cancel = True

End If

End Sub
​

 

[Rick Rothstein]

Thanks for the reply. Since I am very new to vba, so not sure what to suggest

I am not sure what you mean by "what to suggest". Did my code suggestion do what you wanted it to?

 

[erutherford]

No, but everything I have looked at suggest that it should.

 

[Rick Rothstein]

No, but everything I have looked at suggest that it should.

What does happen?

 

[erutherford]

MsgBox appears, select Ok, but I don't get taken back to cell 21,3

 

[erutherford]

Did a simple test in a new workbook and it worked fine. Back to my project and I have the code assigned to "Workbook BeforePrint". Should I assign code to a "button" (macro)?

 

[Rick Rothstein]

Did a simple test in a new workbook and it worked fine. Back to my project and I have the code assigned to "Workbook BeforePrint". Should I assign code to a "button" (macro)?

It sounds to me like you may have other event code which is interfering with the BeforePrint event code.

Should I assign code to a "button" (macro)?

I don't see how that would do what you want (automatic reaction when a user tries to print).

 

[erutherford]

It sounds to me like you may have other event code which is interfering with the BeforePrint event code.




I don't see how that would do what you want (automatic reaction when a user tries to print).

Not sure why it worked, but added the code to a form control button in a new module and it worked. I didn't see any conflicts but at my level it doesn't mean there isn't . I am not sure if putting this in a module is proper. Still have a long road to go down in vba.

Thanks for your effort and at least now I know a little more vba than before!