Msg box color background w/ VBA

[PL01]

Anybody know if message boxes can have their back ground colors changed using VBA? i.e. a yellow message box instead of a gray one?

 

[lameid]

I have never seen a way to do it.

You can however have a modal pop up form with buttons that looks suspiciously like a messagebox. You can of course make a form whatever color you want.

 

[PL01]

...yes but a form will interrupt your VBA code, a message box will not...

 

[MajP]

...yes but a form will interrupt your VBA code, a message box will not...

I believe you have that backward. A VBA message box is always modal and will always halt code execution until closed. A custom form could be modal or modeless.

 

[PL01]

I guess I'm not familiar with modal forms then...

 

[lameid]

Modal is a form property... You can look it up in help.

 

[PL01]

I'll remember that.