| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Choices made available dependent on another selection? | Excel Worksheet Functions | |||
| =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
| Choices | Excel Worksheet Functions | |||
Threaded Mode
