Message Box Question

[Steve001]

Hello Again

I have found this question on here as it has been asked previously many years ago....
I believe the answer maybe still no, but just checking in hope.

Is it possible to to have a msgbox with several buttons that can be custom text ? so it behaves like a box with some radio buttons for example ?

I dont really want to create a userform for this one


I am using office 363 & office 2021

Regards

Steve

 

[HighAndWilder]

Hello Again

I have found this question on here as it has been asked previously many years ago....
I believe the answer maybe still no, but just checking in hope.

Is it possible to to have a msgbox with several buttons that can be custom text ? so it behaves like a box with some radio buttons for example ?

I dont really want to create a userform for this one


I am using office 363 & office 2021

Regards

Steve

You do need a Userform that is dynamic so that it can be controlled from outside the Userform.

 

[Steve001]

Hi,
no i don't . i am using to select some options that then select a formula to be used later on

Steve

 

[Logit]

Steve001:

There are multiple sites that explain adding radio buttons to a message box is not routinely possible. By 'routinely' is meant message
boxes are native to Excel and were designed from the beginning to not allow radio buttons or other controls to be added.

I did find one response on the internet that indicate it might be possible by using API calls however, that approach would be very
intensive ... require a mountain of code and using API calls in that instance places the workbook project and all of Excel at risk
of contamination. Messing with API calls inappropriately can can serious damage to your computer's operating system. In this
particular instance, using API calls is very, very risky and not worth it at all.

Give serious consideration to creating a UserForm that looks exactly like a message box and go from there.

 

[HighAndWilder]

Hi,
no i don't . i am using to select some options that then select a formula to be used later on

Steve

This may be a compromise between the standard MsgBox and a Userform.

It displays a standard VBA MsgBox but with custom button labels.

The return values are the normal button values.
vbOK = 1, vbCancel = 2, vbAbort = 3, vbRetry = 4, vbIgnore = 5, vbYes = 6, vbNo = 7

Create Custom Button Labels for a VBA MsgBox - wellsr.com

 

[Steve001]

Steve001:

There are multiple sites that explain adding radio buttons to a message box is not routinely possible. By 'routinely' is meant message
boxes are native to Excel and were designed from the beginning to not allow radio buttons or other controls to be added.

I did find one response on the internet that indicate it might be possible by using API calls however, that approach would be very
intensive ... require a mountain of code and using API calls in that instance places the workbook project and all of Excel at risk
of contamination. Messing with API calls inappropriately can can serious damage to your computer's operating system. In this
particular instance, using API calls is very, very risky and not worth it at all.

Give serious consideration to creating a UserForm that looks exactly like a message box and go from there.

Yes i saw this too, but gave it a very wide berth to be honest

 

[Steve001]

This may be a compromise between the standard MsgBox and a Userform.

It displays a standard VBA MsgBox but with custom button labels.

The return values are the normal button values.
vbOK = 1, vbCancel = 2, vbAbort = 3, vbRetry = 4, vbIgnore = 5, vbYes = 6, vbNo = 7

Create Custom Button Labels for a VBA MsgBox - wellsr.com

This is how i am currentley doing it, several mesgboxes asking the questions i need to decide the outcome then display a message as a check before carrting out the calculations

Thanks for your answers guys

Steve

 

[Joe4]

Steve001,

Please Note: In the future, when marking a post as the solution, please mark the original post that contains the solution (not your own post acknowledging that some other post was the solution).

 

[Steve001]

Joe4, sorry my mistake