HighAndWilder
Well-known Member
- Joined
- Nov 4, 2006
- Messages
- 660
- Office Version
- 365
- Platform
- Windows
Hi
I would like to be able to use the standard MsgBox button argument settings to pass a value to a custom message box form that
I have developed.
For example :
vbYesNo : 4
vbRetryCancel : 5
vbCritical : 16
and to be able to combine them as required.
For example :
vbYesNo + vbCritical
This example passes a value of 20 which gets reversed engineered by Excel so that the MsgBox function can use the values of 4 and 16
to display the 'Yes' and 'No' buttons and the Critical icon.
Excel seems to display a level of intelligence and handles inappropriate combination of settings in way in which is obvious to the developer.
Does anybody know of a way to create an array of the individual argument values or the approach that I could take in
developing my own?
Cheers
HighAndWilder
I would like to be able to use the standard MsgBox button argument settings to pass a value to a custom message box form that
I have developed.
For example :
vbYesNo : 4
vbRetryCancel : 5
vbCritical : 16
and to be able to combine them as required.
For example :
vbYesNo + vbCritical
This example passes a value of 20 which gets reversed engineered by Excel so that the MsgBox function can use the values of 4 and 16
to display the 'Yes' and 'No' buttons and the Critical icon.
Excel seems to display a level of intelligence and handles inappropriate combination of settings in way in which is obvious to the developer.
Does anybody know of a way to create an array of the individual argument values or the approach that I could take in
developing my own?
Cheers
HighAndWilder