Maybe you could create a userform with 3 buttons (plus cancel???).

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

ARGT wrote:

Hi
I want to invite a user to choose one of three options i.e., 1. Make an
Interest Calculation; 2. Make a Payment; or 3. Add a Debit

I was rather hoping that a message box-like approach could be taken but it
seems there is no easy way to change the Yes/No/Cancel buttons in such a
three-choice box.

Once an option has been selected, then a macro will run accordingly.

Any suggestions?

many thanks

--

Dave Peterson