Hello,

Another question please- is there a way to determine what type of message
box you want to call in VBA. So instead of calling the infomation style box
could I call a stop or warning message? And if I can what is the code I need.

Thank you.
R.

Hi,

Write this line in the VB editor and as soon as you enter the comma you'll
get a scroll window with all the different types you can use

msgbox("hello",

Mike

"VoxBox-Richard" wrote:

Hello,

Another question please- is there a way to determine what type of message
box you want to call in VBA. So instead of calling the infomation style box
could I call a stop or warning message? And if I can what is the code I need.

Thank you.
R.

Look in VBA help for msgbox function to get a list of styles.

There is example code shown.


Gord Dibben MS Excel MVP

On Tue, 5 Aug 2008 13:22:00 -0700, VoxBox-Richard
wrote:

Hello,

Another question please- is there a way to determine what type of message
box you want to call in VBA. So instead of calling the infomation style box
could I call a stop or warning message? And if I can what is the code I need.

Thank you.
R.