Name: Sastry B Tip: How to use a combo box. (Excel attached for clarity) This must be very useful for all those who are in MNCs and have to show their financial/economic nos. in more than one currency. This comes extremely handy.
I have written the core tip in this attachment. You can put more controls and also can put one sheet for "parameters" where you can change the key nos. regards, Sastry 2009/6/30 Ayush Jain <jain_ayus...@yahoo.com> > > Dear Members, > > Thanks for your great response in the Week 26 competition. It was > again great learning for the members of the group. > Let us begin week # 27 quiz with the more spirit. This is last chance > for you to be eligible for June month competition.The winner of week # > 26 will be declared soon. Keep watching this Space...... > > Last Date of Submission of tips : 5th July 2009. > > PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE > CONSIDERED FOR PRIZES. > DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. > > You need to submit your name, Subject & the details of tips and > tricks. > DO let me know if you need any clarifications. > > Let me begin by submitting the first tip for this week competition. > > --------------------------------------------------------------------------------------------------------------------------------------------------- > Name : Ayush Jain > Subject : Skip through your worksheets with a shortcut > Detail : When I'm working on many programs at once (yes, of course I'm > a multitasker — what did you expect?), I use the keyboard shortcut ALT > +TAB to move between open programs. (If you haven't tried this, do so > now — it's a great Microsoft Windows® trick.) > > However, this doesn't work when you're moving between worksheets in > the same workbook. Don't despair; there are a couple of neat little > shortcuts that handle the job quite nicely. > > To move one worksheet to the right > > Press CTRL+PAGE DOWN. > > To move one worksheet to the left > > Press CTRL+PAGE UP. > > Now you can skip through those worksheets with lightning speed and > amaze your friends and coworkers (if they're the type to be amazed by > that sort of thing, of course). > > Who is next ???????????????????? > > ----------------------------------------------------------------------------------------------------------------------------------------------------- > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Combo box example.xls
Description: MS-Excel spreadsheet
