I think that when info is added to a pivot table data source then the table is refreshed the items in the dropbox should display in alphabetical order, currently this does not happen and if you want it you have to re-make the table.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of excel-macros+nore...@googlegroups.com Sent: 12 December 2010 00:01 To: Digest Recipients Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 9 Messages in 6 Topics Today's Topic Summary Group: http://groups.google.com/group/excel-macros/topics * Have idea or suggestion <> for MS Excel ? Submit and win awesome prize [2 Updates] * set my vba password <> through vba code [1 Update] * [No Subject] <> [2 Updates] * Tab name changes, macro <> references old name [2 Updates] * Need help to get the <> collection date with the help of formula [1 Update] * Vlookup in Macro <> [1 Update] Topic: Have idea or suggestion for MS Excel ? Submit and win awesome <http://groups.google.com/group/excel-macros/t/c3d67a316c3e3bc8> prize ayush jain <jainayus...@gmail.com> Dec 11 01:18PM ^ <> Dear members, An awesome opportunity to win prize and be closer to Microsoft Excel. What you need to do ? Just submit the idea or feature that you would like to implement in upcoming version of excel. The best five ideas with maximum votes will get the $10 prize. Not only you can submit the idea but you can also vote other ideas and suggestion. I encourage you to participate yourself and let your friends and colleagues participate in this venture. I really expect one idea from each one of you. This is going to be global series and you will have the chance to learn the upcoming possibilities in excel. I am really proud to be associated with great Excel experts here. :) Best Regards, Ayush Jain Microsoft MVP 2010 ----- null ----- Sent by Sent by ayush jain (jainayus...@gmail.com) Ayush <jainayus...@gmail.com> Dec 11 05:28AM -0800 ^ <> Submit your VOTE , IDEA @ http://goo.gl/mod/psLh Thanks. Topic: set my vba password through vba code <http://groups.google.com/group/excel-macros/t/7337bc8815a9a4dc> Ayush <jainayus...@gmail.com> Dec 11 01:09AM -0800 ^ <> Hi Dharti, Good Question! I just did a quick check of the VBproject object model and don't find anything that indicates it is possible to protect or unprotect a VBproject from within VBA. VBA can only test (read-only) whether a VBproject is protected or not. It would have very interesting implications if a VBproject's protection could be changed from VBA, because it would mean that a VBproject could set or remove its own protection. You might try using SendKeys to actually send the necessary keystrokes to the VBE user interface. Also, you may refer to cpearson website which has wealth of information on VBProject object model. http://www.cpearson.com/excel/vbe.aspx I hope it helps. Please let me know if you are able to find solution from any other source. Good Luck! Keep Posting. Best Regards, Ayush Jain Group Manager Microsoft MVP 2010 P.S. Please use appropriate subject title for quick response. Topic: [No Subject] <http://groups.google.com/group/excel-macros/t/14fbcbe21fa672ca> Jai <jaihumtu...@gmail.com> Dec 11 10:34AM +0530 ^ <> Dear Expet please tell me that how can you excel button in vba coding. Ayush <jainayus...@gmail.com> Dec 11 12:20AM -0800 ^ <> Dear Jai, The question is not clear but I can try to answer. I hope you are asking how to assign VBA coding to button in Excel. If this is right, Follow the below steps : 1) Go to developer tab 2) Click on Insert button on Controls Group. 3) Select a button from Form Controls 4) Design a button in excel 5) Select a macro from "Assign Macro window" 6) Click OK. I hope it helps. Please let us know if any further assistance is required. Keep Posting! Best Regards, Ayush Jain Group Manager Microsoft MVP 2010 p.s. You have not mentioned a subject Title as well. Please keep these things in mind while asking questions. Topic: Tab name changes, macro references old name <http://groups.google.com/group/excel-macros/t/fe2e14ff0f98c2dd> Pete <pacrav...@gmail.com> Dec 10 11:49AM -0800 ^ <> This might be a silly question, bit here goes anyways: Have macro's to repopulate formulas in a given worksheet should it become necessary. If the tab name changes, the macro which calls for a certain sheet()select will not find the sheet referenced in the macro and the macro will not do its job. Is there a way to update the macro to have it reference the new sheet name when changing the sheet name? TIA for ideas. Pete Ayush <jainayus...@gmail.com> Dec 11 12:09AM -0800 ^ <> Hi Pete, No Question is silly question... :) In case the sheet name changes, you can give reference of sheet index. Here is example: USE ------> Sheets(3).Select The digit 3 is the 3rd sheet of the workbook. I hope it helps. Please let us know if you have any further questions. Keep Posting ! Thanks. Best Regards, Ayush Jain Group Manager and Microsoft MVP 2010. On Saturday, December 11, 2010 1:19:03 AM UTC+5:30, Pete wrote:This might be a silly question, bit here goes anyways: Have macro's to repopulate formulas in a given worksheet should it become necessary. If the tab name changes, the macro which calls for a certain sheet()select will not find the sheet referenced in the macro and the macro will not do its job. Is there a way to update the macro to have it reference the new sheet name when changing the sheet name? TIA for ideas. Pete Topic: Need help to get the collection date with the help of formula <http://groups.google.com/group/excel-macros/t/ee7f93615e4f9f0e> "C.G.Kumar" <kumar.bemlmum...@gmail.com> Dec 11 12:32PM +0530 ^ <> No attachment found. Topic: Vlookup in Macro <http://groups.google.com/group/excel-macros/t/479b5b29e1be88d2> Vishal Angre <vishal.k.an...@gmail.com> Dec 11 12:14PM +0530 ^ <> Sub vlookup() Dim lookfor As Range Dim rng As Range Dim col As Integer Set lookfor = ActiveCell.Offset(0, -1) Set rng = ActiveWorkbook.Worksheets("MV").Range("A:C") col = 3 dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0) End Sub -- Thanking You Vishal K. Angre -- ---------------------------------------------------------------------------- ------ 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/pages/discussexcelcom/160307843985936?v=wall <http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > &ref=ts -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
