Good afternoon,
Quick question. Is it possible to change the formatting of a message box? Specifically, the colors - background and text color?
I.e. Change the background color to blue and text to white for the following message box
Sub ConfirmDelete()
Msg = "You have chosen to delete the current record."
Msg = Msg & vbCrLF &vbCrLF
Msg = "Are you sure that you want to delete this record?"
Config = vbYesNo + vbExclamation
msgreturn = msgbox(msg,config)
If msgreturn = vbyes then
Rows(activecell.row).delete
ElseIf msgreturn = vbno then
userform1.show
End if
End sub
Thanks to everyone in advance!
dw
Bookmarks