Set custom Buttons on standard MsgBox using API

I am looking at changing the text on the buttons of a standard MsgBox.

I found code here http://www.excely.com/excel-vba/chan...-buttons.shtml

But I ran (& also stepped through) the code and the buttons still show as Yes and No.

What I am doing wrong? (I am testing this on Windows 7 using Excel 2010 32 bits)

Solved. I found code here and it works http://www.mrexcel.com/forum/excel-q...-question.html

I haven't stopped to work out yet why this works and the first one didn't (This one involves a lot of code - I would have preferred to get the first version running).

heh. same

Still it's cool to see that you can do it this way if you want.

I'd be interested if any forum genius could get the first version (see post #1) to work + make it Office 64 bit compatible + use Hungarian Notation for all variables. I'll rep anyone who can pull this challenge off


In the meantime, I've been playing around with the alternative version (post #2). It is very clunky so I have cleaned it up slightly and made it easier to call (see below). Note that it won't be compatible with Macs (API calls) and it currently isn't compatible with Office 64 bit (I haven't converted the API yet).

Please Login or Register  to view this content.