Excel-based language software
Posted by Bob2000 on January 10, 2002 8:45 AM
Hi! I am currently trying to write a macro to brush up my Spanish. In the first column of an Excel spreadsheet are the Spanish words. In the second column are the English equivalents. More columns may be used in case of additional meanings. How do I get a macro whereby a dialog box would appear when prompted that would randomly ask for the Spanish word for any of the English counterparts in the list (including extended meanings), or the other way round, and where you could write your response and then get a score from 0 to whatever the number of words it asks for(based on the number of words you actually got right on total that could well be over 100!). Additional features may include time limits, past performances, etc. but this is a frill that would be a nice to have only. Thanks for the help!