Bluepoint Design

Practical cost effective solutions   
Macro Express Sample Macro: Multiple Choice Trick

Home
Up
Multiple Choice Trick
Multiple Multiple Choice
Occurrences
Repeat Validation
GoTo
First file
Fax PDF Breakup
Day of Year
Multiple Attachments
Multiple eMail Addresses
Text Padding
Building TSV Files

There is a very useful, and as far as I've been able to divine, unintended trick one can use in the Multiple Choice Menu. The problem I found that I often would send the macro to go look for a varying number of suspects which I wanted to choose from. Normally one might create a multiple choice with several sequential variables T11, T12, and so on but I found this cumbersome not to mention it can suck up a lot of string variables. My solution was to pump multiple suspects into one string variable separated by CRLF. By a fluke this works!

It's simplicity itself. The trick is to stick a CRLF between each suspect and stuff them into one variable. For more information about creating this special non-printing character please check out my CRLF Subroutine page. This technique has many applications like selecting a file from a list of files in a directory or on an FTP site.

Warning: One very important caveat is that the Multiple Choice Menu can only handle 36 items. My solution to this has been to count the number of suspects and if I reach 35 append the T1 with a "More..." and display the results. If the user selects "More..." it will continue to get the next 35 until a set is collected that is less than 35 or the user selected something besides "More...". Don't worry, it's less complicated than it sounds. If someone asks nicely I might add an example here. Someone did ask so I created this page to describe the Multiple Multiple Choice!

Multiple_Choice.mex

Page last updated: 02/05/2008

 
Practical cost effective solutions