View Single Post
Old 10-06-2015, 01:42 PM   #14
Newly Registered User
Join Date: May 2014
Location: Hampshire, England
Posts: 378
Thanks: 240
Thanked 4 Times in 4 Posts
Snowflake68 is on a distinguished road
Re: Run Yes/No MessageBox from MACRO

Originally Posted by spikepl View Post
Look up MsgBox in the documentation.

The second argument specifies what is shown on the popup dialog box, bitwise. So you can specify, e.g., vbInformation + vbYesNo etc, each component having some bit value and the total makes up 52 here. Try it.
What documentation? I understand what you mean about how the bits are made up but im not using vba im using the conditions in a macro and just need to know how to change the icon from a warning triangle to a critical icon.
I have tried changing the numbers but dont get the combination that I need.

I just need Yes and No buttons but want to change the icon. This is my macro;

message box.JPG

Thanks for helping
Snowflake68 is offline   Reply With Quote