please check the attachment if it helps.. best regards, STDEV(i)
note: we need dynamic* Max Value* of ScrollBar so we use Scroolbar from ActiveX Control, instead of from FORM. A little macro wil work each time you change the "career" On Wed, May 11, 2011 at 5:21 PM, karan 1237 <karan1...@gmail.com> wrote: > Respected Sirs/Mam, > > I need your help making my project good. Please find attachment. I will be > very obliged if someone can help me as earlier as possible. > > ---------- > Basically I have to do that when I click on drop down list & select another > career i.e. Building and Construction so In sub career list data should > comes from the Building and construction's sheet and If I select another > career i.e. Catering and Hospitality so data should comes from its list > (Catering and Hospitality) and scroll bar should work with the same. I have > 16 careers so please tell me how can I do this. > > > Thnx in Advance > > ııllllııllıı ~ ♣ кαяαηη ♣ ~ ııllllııllıı > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
ctv_Indirect And Address FUNCTION.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12