vbOK and vbCancel type constants

[capone67]

Hi Gang

I am using the vbOK and vbCancel constants in my current project and would like to know where I can find other constants that are responses to message boxes. I need a vbNew and a vbOpen constant. I know I can create my own and assign them values but I wouldn't want to step of the toes of another constant. Can any one point me in a direction to where I can find what values are already in use for this type of constant?

Ken

 

[HermanvLimbeek]

Check out the Object Browser (F2), Library: VBA, Classes: Globals. Here you'll find all the constants.

 

[RickSpr]

Sorry, but you don't get to create your own MessageBox buttons (and corresponding constants), and New and Open buttons are not provided. I think you'll either have to create your own form to use as a message box, or rephrase your MsgBox text into a yes/no/cancel question. (The other options--Abort, Retry, and Ignore, don't sound like they'd be helpful to you.) Rick Sprague

 

[capone67]

Thanks Herman and Rick

I was able to browse the constants and did not find any constants similar to what I needed so I created my own using the same naming convention for consistency. Rick, that is exactly what I am doing. The reason being twofold. Firstly the MS message box is extremely ugly and secondly they just don't meet my needs as you mentioned.

Once again thanks for your help.

Ken