Input selection choices

[ARGT]

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]

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-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

 

[ARGT]

Thanks for the advice Dave. I have started "playing"around with a user box
and will use the links you provide to have a closer look.

I assume that I can use VB code for a sheet to call up a User Box, get the
input and then close the user box and act upon the input.

 

[Dave Peterson]

Yep.

Check Debra's site for that overview.

Thanks for the advice Dave. I have started "playing"around with a user box
and will use the links you provide to have a closer look.

I assume that I can use VB code for a sheet to call up a User Box, get the
input and then close the user box and act upon the input.

 

[ARGT]

Thanks Dave

Yep.

Check Debra's site for that overview.