Is there a way to customize the "Yes" and "No" button text in a Yes/No Messagebox?

Question

Hey guys, I want to have a message box with two options. Instead of Yes/No I want it to say "LOCK" or "UNLOCK." Any way of accomplishing this?

Answer 1

Hi,
I'm afraid it would be impossible.  Please create a Form with two buttons "LOCK" and "UNLOCK".
Regards,

---

Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

Answer 2

You may like to look at http://www.devhut.net/2017/03/24/great-access-tools-enhanced-message-box/

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 3

There is also the API way... check here:http://shutupdean.com/blog/2014/08/01/vba-msgbox-custom-button-text/

Answer 4

Hey John,

I have never used APIs before. I went to the link and downloaded the link provided and it just downloaded a blank excel document, now what?

Answer 5

Alt.+ F11 to get to VBE...just check the code

Answer 6

I see, I figured as much. Was just wondering why he didn't just post the function codes lol.

Answer 7

Hey guys, I want to have a message box with two options. Instead of Yes/No I want it to say "LOCK" or "UNLOCK." Any way of accomplishing this?

For another API solution, there's this:

    http://vbnet.mvps.org/index.html?code/hooks/messageboxhook.htm

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

Answer 8

Hi,

This thread seems to be closed by the original poster, but it continues.
So, I made a sample UserForm like a message box.


I've shared it (UserForm_Msgbox.xlsm) via OneDrive.
Please download and try it.

Regards,

---

Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

Answer 9

Hey guys, I want to have a message box with two options. Instead of Yes/No I want it to say "LOCK" or "UNLOCK." Any way of accomplishing this?

For another API solution, there's this:

    http://vbnet.mvps.org/index.html?code/hooks/messageboxhook.htm

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

This code can't be used on 64-bit apparently.

Answer 10

There is also the API way... check here:http://shutupdean.com/blog/2014/08/01/vba-msgbox-custom-button-text/

Tried this API you shared John and even used the sample code provided in the link for testing on a command button. It makes my database "stop working."