<

How to use Excel's Choose function

Posted on
6,014 Points
14 Views
Last Modified:
Published
Experience Level: Intermediate
6:47
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
With Excel’s Choose function, you can create a list of items, then select which of those items you want the function to return. For example, if you have a list of ice cream flavors that’s chocolate, vanilla, and coffee and specify item #2, the function will return “vanilla”.
0
Author:Bob Flisser
0 Comments
Windows Explorer lets you open archive (tar and tgz) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating archive files takes a little more - and that you'll find here.
When adding new VBA features to a workbook, some parts may be difficult but you struggle through it because it's important to you or to someone you're helping. During that struggle you may say to yourself that "I wish I could find an easier way". Ho…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month