Input selection choices
 

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

Input selection choices
 

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

Input selection choices
 

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" wrote:

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

Input selection choices
 

Yep.

Check Debra's site for that overview.

ARGT wrote:

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" wrote:

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


--

Dave Peterson

Input selection choices
 

Thanks Dave

"Dave Peterson" wrote:

Yep.

Check Debra's site for that overview.

ARGT wrote:

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" wrote:

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


--

Dave Peterson