Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
This is a very important tool to convert no. in figures into words: STEPS: 1) Download the attachment and save it to hard disk. 2) Open excels and goes to Tools -Add Ins 3) Go to browse and select the smb.xla file from the location where u saved it and click OK. USE the Formula =ntow (amount in figure or cell reference Regards Amir On Tue, Feb 8, 2011 at 2:10 PM, solomon raju faithful1...@gmail.com wrote: Vishal, Thank you very much. Regards, Solomon On Tue, Feb 8, 2011 at 12:19 PM, Vishal Gupta vgsca.19802...@gmail.comwrote: Hi Soloman, Try the sheet attached by me, it will definitly help you. Regards CA. Vishal Gupta 9463647598 On Thu, Feb 3, 2011 at 4:44 PM, solomon raju faithful1...@gmail.comwrote: Hi All, Please find the attached excel file and give me some formula to convert the amount in text. Regards, Solomon -- -- 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 -- -- 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 -- Regards, Solomon -- -- 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 -- -- 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 smb.xla Description: Binary data
Re: $$Excel-Macros$$ help pls : find first non empty row in range
thanks a lot!!! superb From: ashish koul koul.ash...@gmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 5:33:44 AM Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range check the attachment On Wed, Feb 9, 2011 at 8:32 AM, danial mansoor danial_...@hotmail.com wrote: use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E260,E17:E26)) Date: Tue, 8 Feb 2011 17:05:33 -0800 Subject: $$Excel-Macros$$ help pls : find first non empty row in range From: lupins...@yahoo.com To: excel-macros@googlegroups.com Hi All, I hope you will help me in maybe something that is so simple, but I've sent last 2 hours to sort it out without any conclusion. :( The problem is: I need to find first cell that is bigger then 0 in the specific range. HELP!!! PS I'd like to add an attachement but I don't know how, so e.g.: column X 0 0 0 0 7 6 7 0 0 0 -- -- - 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 -- -- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- -- 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 The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php -- -- 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
Re: $$Excel-Macros$$ help pls : find first non empty row in range
thanks!!! From: danial mansoor danial_...@hotmail.com To: excel-macros@googlegroups.com Sent: Wed, February 9, 2011 4:02:58 AM Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an array formula it ll give u 7 answer.u =MAX(IF(E17:E260,E17:E26)) Date: Tue, 8 Feb 2011 17:05:33 -0800 Subject: $$Excel-Macros$$ help pls : find first non empty row in range From: lupins...@yahoo.com To: excel-macros@googlegroups.com Hi All, I hope you will help me in maybe something that is so simple, but I've sent last 2 hours to sort it out without any conclusion. :( The problem is: I need to find first cell that is bigger then 0 in the specific range. HELP!!! PS I'd like to add an attachement but I don't know how, so e.g.: column X 0 0 0 0 7 6 7 0 0 0 -- -- - 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 -- -- 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 Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL -- -- 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
RE: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
Thanks Ashish, Works great. Regards - Dave. Date: Wed, 9 Feb 2011 10:32:26 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com try this On Wed, Feb 9, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.com wrote: @ dave Try this Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi Ashish, Thanks for sending the file. Excellent. But for some reason, selecting a cell with the left mouse button isn't recognised. I tried adding Rob's code, but it didn't work properly either. It only worked when using the left mouse button to 'OK' a previous message box. Regards - Dave Date: Wed, 9 Feb 2011 09:03:03 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com hi dave, see if this helps On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack davebonall...@hotmail.com wrote: Hi Rob, I am interested in the trapping of a left mouse click, but couldn't understand it from your posts. Could you please attach a workbook with working code? Regards - Dave. Date: Tue, 8 Feb 2011 05:14:53 -0800 Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: robert.a.cama...@gmail.com To: excel-macros@googlegroups.com solved it: I had to add a bit mask (i think thats what its called). This returned true when I clicked on a cell: If CBool(GetAsyncKeyState(1) 128) Then MsgBox (left click trapped) End If (1) is the constant for left mouse click On Feb 7, 11:28 am, rcamarda robert.a.cama...@gmail.com wrote: Hi, I am trying to trap a left mouse click. I found lots of uses of GetAsyncKeyState, however, even something simple is not working. Private Declare Function GetAsyncKeyState Lib user32.dll (ByVal vKey As Long) As Integer Private Sub Worksheet_SelectionChange(ByVal Target As Range) If GetAsyncKeyState(VK_LBUTTON) Then MsgBox (left click trapped) End If If GetAsyncKeyState(VK_BACK) Then MsgBox (back space) End If If GetAsyncKeyState(VK_RETURN) Then MsgBox (enter key) End If End Sub Should I use a different library when using x64 or Office 2010?? TIA Rob -- -- 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 -- -- 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 -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
hi dave check this link see if helps http://itknowledgeexchange.techtarget.com/beyond-excel/back-to-controlling-the-cursor/ On Wed, Feb 9, 2011 at 2:08 PM, Dave Bonallack davebonall...@hotmail.comwrote: Thanks Ashish, Works great. Regards - Dave. -- Date: Wed, 9 Feb 2011 10:32:26 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com try this On Wed, Feb 9, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.comwrote: @ dave Try this Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Ashish, Thanks for sending the file. Excellent. But for some reason, selecting a cell with the left mouse button isn't recognised. I tried adding Rob's code, but it didn't work properly either. It only worked when using the left mouse button to 'OK' a previous message box. Regards - Dave -- Date: Wed, 9 Feb 2011 09:03:03 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com hi dave, see if this helps On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Rob, I am interested in the trapping of a left mouse click, but couldn't understand it from your posts. Could you please attach a workbook with working code? Regards - Dave. Date: Tue, 8 Feb 2011 05:14:53 -0800 Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: robert.a.cama...@gmail.com To: excel-macros@googlegroups.com solved it: I had to add a bit mask (i think thats what its called). This returned true when I clicked on a cell: If CBool(GetAsyncKeyState(1) 128) Then MsgBox (left click trapped) End If (1) is the constant for left mouse click On Feb 7, 11:28 am, rcamarda robert.a.cama...@gmail.com wrote: Hi, I am trying to trap a left mouse click. I found lots of uses of GetAsyncKeyState, however, even something simple is not working. Private Declare Function GetAsyncKeyState Lib user32.dll (ByVal vKey As Long) As Integer Private Sub Worksheet_SelectionChange(ByVal Target As Range) If GetAsyncKeyState(VK_LBUTTON) Then MsgBox (left click trapped) End If If GetAsyncKeyState(VK_BACK) Then MsgBox (back space) End If If GetAsyncKeyState(VK_RETURN) Then MsgBox (enter key) End If End Sub Should I use a different library when using x64 or Office 2010?? TIA Rob -- -- 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 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks
$$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter
Hey Friends, Here is something interesting for you. *Love is in the air*, do some automation and *save your time for your loved ones*. Hope this helps you :) 1. Collection of VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html 2. Access a search Engine like Google, Bing or E-Bay on Internet Explorer using VBAhttp://www.excelitems.com/2009/03/access-search-engines-on-browser.html 3. Learn how to use VLOOKUP function.http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html 4. Remove VBA Code using VBAhttp://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html 5. Export Excel Charts to Powerpointhttp://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html 6. Embed Adobe Flash in MS Excelhttp://www.excelitems.com/2009/03/how-to-embed-flash-in-excel-office.html 7. Learn how to use ARRAY Formulashttp://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html 8. Validate E-mail addresseshttp://www.excelitems.com/2010/11/validate-e-mail-addresses.html 9. Schedule a VBA Macrohttp://www.excelitems.com/2010/11/schedule-vba-macro-alarm-setting.html 10. Speed up Excel Start up (FASTER EXCEL)http://www.excelitems.com/2010/11/speed-up-excel-start-up-faster-excel.html 11. Shrink or Reduce Excel File Size (From MBs to KBs)http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html -- Excel VBA Interview Questionshttp://www.excelitems.com/2010/12/excel-vba-interview-questions.html Collection of Excel VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html VLOOKUPhttp://www.excelitems.com/2009/03/how-to-use-vlookup-function.html OFFSEThttp://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more ARRAY formulashttp://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html -- Excel 2003 Style Menu in Excel 2007http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html Custom Number Formathttp://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html SUMIFShttp://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html CONTACT a TRAINERhttp://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html -- Thanks Regards -- Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com Facebook http://www.facebook.com/eXceLiTems Twitterhttp://www.twitter.com/eXceLiTems LinkedIn http://in.linkedin.com/in/ashishjain08 LiveJournalhttp://livejournal.excelitems.com/ Digg http://digg.com/excelitems Delicioushttp://www.delicious.com/save?new=1url=http%3A%2F%2Fwww.excelitems.com%2Ftitle=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloadstype=BOOKMARKjump=http://www.delicious.com%2Fmountintkey=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-copyuser=mountintvia=mountintcopytags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com Subscribe to Emailhttp://feedburner.google.com/fb/a/mailverify?uri=excelitems -- -- -- 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
RE: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter
Can some one help me in the following problems with excel 2003? When I save file a .tmp file saves and when I delete again .tmp saves along with the orginal .xls file Please help Reply me on tolontino.go...@pepsidrc.aemailto:tolontino.go...@pepsidrc.ae From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of OpenExcel.com Sent: Wednesday, February 09, 2011 2:13 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter Hey Friends, Here is something interesting for you. Love is in the air, do some automation and save your time for your loved ones. Hope this helps you :) 1. Collection of VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html 2. Access a search Engine like Google, Bing or E-Bay on Internet Explorer using VBAhttp://www.excelitems.com/2009/03/access-search-engines-on-browser.html 3. Learn how to use VLOOKUP function.http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html 4. Remove VBA Code using VBAhttp://www.excelitems.com/2009/04/delete-or-remove-event-macros-vba-code.html 5. Export Excel Charts to Powerpointhttp://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html 6. Embed Adobe Flash in MS Excelhttp://www.excelitems.com/2009/03/how-to-embed-flash-in-excel-office.html 7. Learn how to use ARRAY Formulashttp://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html 8. Validate E-mail addresseshttp://www.excelitems.com/2010/11/validate-e-mail-addresses.html 9. Schedule a VBA Macrohttp://www.excelitems.com/2010/11/schedule-vba-macro-alarm-setting.html 10. Speed up Excel Start up (FASTER EXCEL)http://www.excelitems.com/2010/11/speed-up-excel-start-up-faster-excel.html 11. Shrink or Reduce Excel File Size (From MBs to KBs)http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html Excel VBA Interview Questionshttp://www.excelitems.com/2010/12/excel-vba-interview-questions.html Collection of Excel VBA Macroshttp://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html VLOOKUPhttp://www.excelitems.com/2009/03/how-to-use-vlookup-function.html OFFSEThttp://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more ARRAY formulashttp://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html Excel 2003 Style Menu in Excel 2007http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html Custom Number Formathttp://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html SUMIFShttp://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html CONTACT a TRAINERhttp://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html Thanks Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.comhttp://www.excelitems.com/ http://www.openexcel.comhttp://www.openexcel.com/ Facebookhttp://www.facebook.com/eXceLiTems Twitterhttp://www.twitter.com/eXceLiTems LinkedInhttp://in.linkedin.com/in/ashishjain08 LiveJournalhttp://livejournal.excelitems.com/ Digghttp://digg.com/excelitems Delicioushttp://www.delicious.com/save?new=1url=http%3A%2F%2Fwww.excelitems.com%2Ftitle=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloadstype=BOOKMARKjump=http://www.delicious.com%2Fmountintkey=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-copyuser=mountintvia=mountintcopytags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com Subscribe to Emailhttp://feedburner.google.com/fb/a/mailverify?uri=excelitems -- -- 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 -- -- 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
$$Excel-Macros$$ Shorting Problems
Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ -- -- 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 Book1.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
Sorry for the rabbit hole...I posted too quickly and once it was sent, I couldnt retract. I still can not get it to work. Latest I tried is this, which always says left click has been pressed code: On a module I have: Public Declare Function GetAsyncKeyState Lib user32 (ByVal vKey As Long) As Integer (some postings change the return type and the parameter types) In my sheet I have: Sub Worksheet_SelectionChange(ByVal Target As Range) If (GetAsyncKeyState(vbKeyRButton)) Then MsgBox You have clicked the right button! 'when you click right button ElseIf (GetAsyncKeyState(vbKeyLButton) ) Then MsgBox You have clicked the left button! 'when you click left button End If End Sub I checked out: http://itknowledgeexchange.techtarget.com/beyond-excel/back-to-controlling-the-cursor/ and noticed how the author cheated when it came to mouse :) I've added the H8000 bit mask, but still nothing on the left mouse click. On Feb 9, 3:52 am, ashish koul koul.ash...@gmail.com wrote: hi dave check this link see if helpshttp://itknowledgeexchange.techtarget.com/beyond-excel/back-to-contro... On Wed, Feb 9, 2011 at 2:08 PM, Dave Bonallack davebonall...@hotmail.comwrote: Thanks Ashish, Works great. Regards - Dave. -- Date: Wed, 9 Feb 2011 10:32:26 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com try this On Wed, Feb 9, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.comwrote: @ dave Try this Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Ashish, Thanks for sending the file. Excellent. But for some reason, selecting a cell with the left mouse button isn't recognised. I tried adding Rob's code, but it didn't work properly either. It only worked when using the left mouse button to 'OK' a previous message box. Regards - Dave -- Date: Wed, 9 Feb 2011 09:03:03 +0530 Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: koul.ash...@gmail.com To: excel-macros@googlegroups.com hi dave, see if this helps On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi Rob, I am interested in the trapping of a left mouse click, but couldn't understand it from your posts. Could you please attach a workbook with working code? Regards - Dave. Date: Tue, 8 Feb 2011 05:14:53 -0800 Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64 From: robert.a.cama...@gmail.com To: excel-macros@googlegroups.com solved it: I had to add a bit mask (i think thats what its called). This returned true when I clicked on a cell: If CBool(GetAsyncKeyState(1) 128) Then MsgBox (left click trapped) End If (1) is the constant for left mouse click On Feb 7, 11:28 am, rcamarda robert.a.cama...@gmail.com wrote: Hi, I am trying to trap a left mouse click. I found lots of uses of GetAsyncKeyState, however, even something simple is not working. Private Declare Function GetAsyncKeyState Lib user32.dll (ByVal vKey As Long) As Integer Private Sub Worksheet_SelectionChange(ByVal Target As Range) If GetAsyncKeyState(VK_LBUTTON) Then MsgBox (left click trapped) End If If GetAsyncKeyState(VK_BACK) Then MsgBox (back space) End If If GetAsyncKeyState(VK_RETURN) Then MsgBox (enter key) End If End Sub Should I use a different library when using x64 or Office 2010?? TIA Rob -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 -- ------ 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 -- *Regards* * *
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.com wrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added the = 1 I had, and some of my test sheets worked. 3. It didnt work when i put it into my sheet where I needed it, GetAsyncKeyState(vbKeyLButton) = 1 And H8000 but it didnt work 4. I opened a fresh excel, pasted your code and it worked. 5. My sheet has macro enabled, so I saved your test book as xlsm and your test still works. 6. I can create a new sheet in my excel, and the code works on that sheet. so some sheets it works, others it does not. 7. On the sheet I need to trap the mouse, all code in your test works, except the left mouse. In other sheets it traps everything 8. When I use only MsgBox GetAsyncKeyState(vbKeyLButton) in my Worksheet_SelectionChange, it shows just 0 (zero). start *rips hair out* /start Anyone have ideas on how to determine why my sheet doesnt work, but a blank fresh one does? -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
r u using right button also On Wed, Feb 9, 2011 at 7:53 PM, ashish koul koul.ash...@gmail.com wrote: can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.comwrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added the = 1 I had, and some of my test sheets worked. 3. It didnt work when i put it into my sheet where I needed it, GetAsyncKeyState(vbKeyLButton) = 1 And H8000 but it didnt work 4. I opened a fresh excel, pasted your code and it worked. 5. My sheet has macro enabled, so I saved your test book as xlsm and your test still works. 6. I can create a new sheet in my excel, and the code works on that sheet. so some sheets it works, others it does not. 7. On the sheet I need to trap the mouse, all code in your test works, except the left mouse. In other sheets it traps everything 8. When I use only MsgBox GetAsyncKeyState(vbKeyLButton) in my Worksheet_SelectionChange, it shows just 0 (zero). start *rips hair out* /start Anyone have ideas on how to determine why my sheet doesnt work, but a blank fresh one does? -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
Im not using the right mouse. If you suggest that I use the right mouse, I'd need to disable the format popup if I am in my target cell. IE If Target.Count = 1 and Target.Column = 34 and Target.Value 0 And (GetAsyncKeyState(vbKeyLButton) = 1 And H8000) Then ' my logic End If On Feb 9, 9:25 am, ashish koul koul.ash...@gmail.com wrote: r u using right button also On Wed, Feb 9, 2011 at 7:53 PM, ashish koul koul.ash...@gmail.com wrote: can you share your workbook On Wed, Feb 9, 2011 at 6:57 PM, rcamarda robert.a.cama...@gmail.comwrote: Ashish, 1. Your code worked from your example. 2. in my other tests, I added added the = 1 I had, and some of my test sheets worked. 3. It didnt work when i put it into my sheet where I needed it, GetAsyncKeyState(vbKeyLButton) = 1 And H8000 but it didnt work 4. I opened a fresh excel, pasted your code and it worked. 5. My sheet has macro enabled, so I saved your test book as xlsm and your test still works. 6. I can create a new sheet in my excel, and the code works on that sheet. so some sheets it works, others it does not. 7. On the sheet I need to trap the mouse, all code in your test works, except the left mouse. In other sheets it traps everything 8. When I use only MsgBox GetAsyncKeyState(vbKeyLButton) in my Worksheet_SelectionChange, it shows just 0 (zero). start *rips hair out* /start Anyone have ideas on how to determine why my sheet doesnt work, but a blank fresh one does? -- --- --- 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 athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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
Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64
Here it is (I used the new google groups ) -- -- 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 mouse test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Shorting Problems
Hi Sudhir, Select the row A = Click on Data Tab = Click on Advanced = Select Unique Records Only. That's it. Regards Umesh On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ -- -- 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 -- -- 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
Re: $$Excel-Macros$$ Shorting Problems
Hi Sudhir, please find the attachment and check it, On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar bluecore...@gmail.com wrote: Dear Frnd I have list which have many repeated names i want short it with formula thanx -- Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. * * * *Happy **Valentine** Day * \ ¦ / (ò ó) _ ___o0o___(_)___o0o__ ___¦_¦_¦_¦_¦ ¦_¦_¦_¦_¦__ ___¦_¦_¦_¦_¦ -- -- 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 -- One Team One Dream One Goal Warm Regards, *Vikas Chauhan* E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, We can't Spell S_*ccess *without U Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- 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 Sorting Name.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Question for you Excel Masters out there...
Greetings, I have a question I am hoping to find the answer of here... I have a spreadsheet that signifies that includes revenue which is represented on my pivot charts as bars represented by a month (a good example but I could come up with others of course). Simple enough right? Well what if I have another metric that I am wanting to track that is a drastically different number (average product cost to customer) that I want to have on the same chart with that number formatted as currency looking all nice and professional. How do I do it? Anyone that helps gets 1,000 thank yous on top of the 1,000 I am giving to all who read this far ;-) 1,000 Thank you's to you all! -Michael -- -- 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
Re: $$Excel-Macros$$ Passing Variable to another function
Hi Paul, Sorry for late reply as i was out of town i couldnt check this out. Thanks a lot paul for your detail explanation.and really sorry for creating confusion. my que is Can a variable be passed to a function without initializing it and getting their values. i have explained in detail below. 1. that variable is declared as global variable but it has not initialised anywer. 2. the called function work on that global variable which is passed to the called fucntion and changes its value but that function jus return true or False nothing else. then how that variable is assigned some value. please find the example below dim workingday as some data type workingday this is declared as global variable. Sub calling () if not (calculateworkingday(workingday)) then 'here we are passing that variable to some function . end sub 'calculateworkingday this is called function public function calculateworkingday(abcd as some datatype) boolean ' in this code we use 'abcd' variable and not that actual global variable. 'using this 'abcd' variable we change the value of 'abcd' 'this function jus return 'true' or 'false' then how that acual value is changed? is it bcoz that variable is global? i tried same kind of thing i.e. passing global variable without initialising it but i got error. calculateworkingday = true end function From: Paul Schreiner schreiner_p...@att.net To: excel-macros@googlegroups.com Sent: Mon, 7 February, 2011 11:41:24 PM Subject: Re: $$Excel-Macros$$ Passing Variable to another function Your question is a bit confusing: You want to know if we can pass the variables without initializing them to any other function and get their values from that called function Initializing a variable is not the same as Declaring a variable. Dim workingday as Integer Declares the variable WorkingDay as type Integer. Workingday = 0 Initializes the variable, or sets the Initial Value to 0. When a variable is first Declared, it's value is usually null. - If your question really is: Can a variable be passed to a function without initializing it, then the answer depends on what the function does with the variable. If the function uses a statement like: If WorkingDay = 0 then it may produce an error if WorkingDay is null, because the resulting statement is: If = 0 then If your question is if we can pass the variables without DECLARING them: The answer here is based on the understanding of Variable Declarations. First of all, using: Option Explicit will cause the compiler to require that ALL variables be declared before being used. But if Option Explicit is NOT used: Rule #1: to a compiler, ALL variables are DECLARED. The question is: when/where are they declared? You can declare them Explicitly by using: Dim NewVariable but WHERE this statement is placed is important too! If you have a macro/Sub called Calling, and use: Dim VarModLevel Sub Calling() Dim VarSubLevel then the Variable VarSubLevel is available ONLY within the Subroutine. While VarModLevel is available to all subs in the Module. However, it would NOT be available to Userforms and when macros complete. Now, OUTSIDE of a subroutine, you can use: Global VarGlobal or Public VarPublic These variables are available until Excel exits. a second way to declare variables is when passing a value to a function: Function Calling(LocalVar) will Declare a new variable LocalVar that is only available within the function. Now.. if you are NOT using Option Explicit, then variables can be used WITHOUT first declaring them. This means that when you use: IntVar = 100 The variable IntVar is automatically declared as if you used: Dim IntVar as Integer However, more often, Excel chooses to declare the variable as type Variant (Dim IntVar as Variant) At the same time, if you use: IntVar = 100, then it gets declared as a STRING variable as if you used: Dim IntVar as String. subsequent attempts to use is as a number: IntVar = IntVar + 1 will produce an error. --- So.. to answer your actual question: if we can pass the variables without initializing them to any other function and get their values from that called function The problem in your example is that your function: CalculateWorkingDay(abcd as some datatype) abcd is declared as a specifid data type. That means that the variable passed TO the function: WorkingDay in: CalculateWorkingDay(WorkingDay) must be the same data type. To test this type of thing, try this: Option Explicit Global TestVar Sub Testing() TestVar = 1 MsgBox Testing: TestVar = TestVar Test2 MsgBox Testing2: TestVar = TestVar End Sub Sub Test2() Dim TestVar, stat TestVar = 2 MsgBox Test2: TestVar = TestVar stat = TestFunction(TestVar) MsgBox Test2a: TestVar = TestVar End Sub Function
