Bold fonting a msgbox.

[countryfan_nt]

Hello friends,

This should be easy, I am trying to bold the msgbox font.
Please help me,
Thanks,
Nawaf

Sub WORKBOOK_OPEN()
If Sheets("DAY OFF").Range("W4") <> Year(Now()) Then
MsgBox ("You Need To Place The Current Year In Cell W4!")

End If
End Sub

 

[tusharm]

Two comments.

(1) AFAIK, you cannot change the font characteristics of the msgbox on the fly.

(2) If you know the cell is supposed to contain the current year, why not put it there? The same code that asks the customer to do it could itself do the needful!