$$Excel-Macros$$ Re: Looking for a finance spreadsheet
hi, you can have templates in various excel websites and also you can find some templates in Excel 2007 version open command button On 6/6/09, Rajesh Janardanan wrote: > > hi ryan, > u sound to know debit and credit well , u can do the spreadsheet your self > , please try > > cheers > > > On Sat, Jun 6, 2009 at 9:51 AM, spazlon wrote: > >> >> Hello, >> >> I am looking for a personal finance spreadsheet. I tried making one of >> my own, but quickly realized I lacked the knowledge to do what I >> wanted. Basically I want to have one sheet that will have all of my >> transactions on it with a Debit and Credit column. I will also have a >> sheet for each of my accounts. When I add a transaction to my main >> sheet, I want it to reflect in the corresponding account sheets. >> >> For example, if I debit $100 from Checking and credit Savings, I want >> that row to appear on the Checking and Savings sheets as well. >> >> Does anybody have a sheet that will do this? >> >> Thanks! >> >> - Ryan >> >> >> -- P.VIJAY KUMAR --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Doubt on data range
Hi Ramesh, Please checkout the file attached with sollution. Vinayak Hegde From: Ramesh Katta To: excel-macros@googlegroups.com Sent: Sunday, 7 June, 2009 5:24:38 PM Subject: $$Excel-Macros$$ Doubt on data range Dear Members, My question seems to be very simple, please don't laugh at me. I have 2 columns that are A1 contains Names and B1 contains Sex of employee. When finding no. of males and females using countif() function. When I copied the function I am getting range difference. For ex: =countif(a2:a10,"M") when I copied this range to below cell and changed criteria to "F" but it taking range from a3:a10. Please clarify this doubt. This was asked in interview. I attached excel sheet with this mail. Thanks&Regards Ramesh Bollywood news, movie reviews, film trailers and more! Go to http://in.movies.yahoo.com/ --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- Data%20Range%20%28countif%29(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Tip of the week
Hi all, Name : Ramesh Subject : Open a workbook which has formule. Tip :Use Ctrl+` to see the all formule which are in the sheet. We use Ctrl+` to see the all used formulas in the current worksheet. Thanks&Regards Ramesh Katta --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Doubt on data range
Hi, Narendra, Thank you very much for helping on time. Regards Ramesh On Sun, Jun 7, 2009 at 8:13 PM, CA NARENDRA ASHARA wrote: > Dear Ramesh, > > You need to freeze the range by F4. Please find the solution in the attached > sheet. > > Thanks & Regards, > Narendra > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of Ramesh Katta > Sent: 07 June, 2009 5:25 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Doubt on data range > > Dear Members, > > My question seems to be very simple, please don't laugh at me. > > I have 2 columns that are A1 contains Names and B1 contains Sex of employee. > When finding no. of males and females using countif() function. When I > copied the function I am getting range difference. > > For ex: > > =countif(a2:a10,"M") when I copied this range to below cell and changed > criteria to "F" but it taking range from a3:a10. > > Please clarify this doubt. This was asked in interview. > > I attached excel sheet with this mail. > > Thanks&Regards > Ramesh > > > > > > --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ WARNING SIGNAL IN CASE OF ERROR
Dear All groupmembers, I prepare financial statements in excel. To check whether the balance sheet tallied I check assets - liabilities in a particular cell which should be zero and add it to watch window. Is it possible that every time I open/save the file it would give me warning message that my balance sheet does not tally in case of any difference in assets and liabilities. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (0361-2603895,9435019908 --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- <><>
$$Excel-Macros$$ Re: Doubt on data range
Hi Ramesh, The formulas should be: =countif($a$2:$a$10,"M") =countif($a$2:$a$10,"F") Then you can paste them anwhere on the sheet and get the same answer. Without the $ signs, the range reference will change depending on where you paste the formula. Regards - Dave. > Dear Members, > > My question seems to be very simple, please don't laugh at me. > > I have 2 columns that are A1 contains Names and B1 contains Sex of > employee. When finding no. of males and females using countif() > function. When I copied the function I am getting range difference. > > For ex: > > =countif(a2:a10,"M") when I copied this range to below cell and > changed criteria to "F" but it taking range from a3:a10. > > Please clarify this doubt. This was asked in interview. > > I attached excel sheet with this mail. > > Thanks&Regards > Ramesh > > > _ Get the latest news, goss and sport Make ninemsn your homepage! http://windowslive.ninemsn.com.au/article.aspx?id=813730 --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Doubt on data range
Dear Ramesh, You need to freeze the range by F4. Please find the solution in the attached sheet. Thanks & Regards, Narendra -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Ramesh Katta Sent: 07 June, 2009 5:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Doubt on data range Dear Members, My question seems to be very simple, please don't laugh at me. I have 2 columns that are A1 contains Names and B1 contains Sex of employee. When finding no. of males and females using countif() function. When I copied the function I am getting range difference. For ex: =countif(a2:a10,"M") when I copied this range to below cell and changed criteria to "F" but it taking range from a3:a10. Please clarify this doubt. This was asked in interview. I attached excel sheet with this mail. Thanks&Regards Ramesh --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- Copy of Data Range (countif).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Doubt on data range
Dear Members, My question seems to be very simple, please don't laugh at me. I have 2 columns that are A1 contains Names and B1 contains Sex of employee. When finding no. of males and females using countif() function. When I copied the function I am getting range difference. For ex: =countif(a2:a10,"M") when I copied this range to below cell and changed criteria to "F" but it taking range from a3:a10. Please clarify this doubt. This was asked in interview. I attached excel sheet with this mail. Thanks&Regards Ramesh --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~--- Data Range (countif).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Looking for a finance spreadsheet
There is an account register at: http://scribd.com/ncmay Norman On Sat, Jun 6, 2009 at 11:36 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Ryan, > > Did you tried templates on Microsoft website? Here is the link, plz > reply with your feedback. > > http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL > > Here you'll find templates on > Receipts > Invoices > Budget > Inventories > and Expense reports etc. > > - > Regards > Ashish Jain > http://www.excelitems.com > http://www.openexcel.com > *Developer of Open XL* > - > > > On Jun 6, 11:51 am, spazlon wrote: > > Hello, > > > > I am looking for a personal finance spreadsheet. I tried making one of > > my own, but quickly realized I lacked the knowledge to do what I > > wanted. Basically I want to have one sheet that will have all of my > > transactions on it with a Debit and Credit column. I will also have a > > sheet for each of my accounts. When I add a transaction to my main > > sheet, I want it to reflect in the corresponding account sheets. > > > > For example, if I debit $100 from Checking and credit Savings, I want > > that row to appear on the Checking and Savings sheets as well. > > > > Does anybody have a sheet that will do this? > > > > Thanks! > > > > - Ryan > > > --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Looking for a finance spreadsheet
Hi Ryan, This seems interesting... and this can be done... i can do this for you... just an advise, do you really want to have one sheet for each account, or will it be better to keep all the transactions in on sheet (that will be the database) and then have a sheet than can pull transaction of each account... whats your thoughts Nishant On Jun 7, 8:36 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Ryan, > > Did you tried templates on Microsoft website? Here is the link, plz > reply with your feedback. > > http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL > > Here you'll find templates on > Receipts > Invoices > Budget > Inventories > and Expense reports etc. > > - > Regards > Ashish Jainhttp://www.excelitems.comhttp://www.openexcel.com > *Developer of Open XL* > - > > On Jun 6, 11:51 am, spazlon wrote: > > > > > Hello, > > > I am looking for a personal finance spreadsheet. I tried making one of > > my own, but quickly realized I lacked the knowledge to do what I > > wanted. Basically I want to have one sheet that will have all of my > > transactions on it with a Debit and Credit column. I will also have a > > sheet for each of my accounts. When I add a transaction to my main > > sheet, I want it to reflect in the corresponding account sheets. > > > For example, if I debit $100 from Checking and credit Savings, I want > > that row to appear on the Checking and Savings sheets as well. > > > Does anybody have a sheet that will do this? > > > Thanks! > > > - Ryan --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement
Ashish, Thank you for the information. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserForm Initializing after if.. then statement Hi Alokeshwar, This is absolutely normal. 1. When you try to fetch the values from userform1, it is initialized and new value of Test set upon. To avoid this you can use activate event of userform1. Difference between activate and initialize is of Foreground visibility active state and Background invisible initiation state. 2. But the above solution is a mere Jugad technique. Look below to intelligently correct your problem Instead of using If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" Then use this If UserForm1.TextBox1 <> "SomeValue" AND UserForm2.TextBox1 <> "SomeValue" Then and then it'll display same value across both Msgbox in UserForm2. Hope you'll understand the difference. Let me explain with example for all excel users. When we use boolean expression similar to this A OR B OR C. The order of evaluation is C --> B --> A. If C is True, then it don't evaluates A and B and the result of expression becomes true. But When we use boolean expression similar to this A AND B AND C. The order of evaluation is A --> B --> C. If A is False, then it don't evaluates C and B and the result of expression becomes False. If you carefully see the code and run using F8, you'll better understand the above 2 points. Try with different expressions to really learn this. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 3:11 pm, Alokeshwar Tiwary wrote: > Dear All, > > I encountered a very strange problem. I have two userforms and both of them > define values for few variables at Initialize event and also they both refer > to each other to verify certain conditions. Now what's happening is - > immediately after if.. then statement, the variables change .. as if the > other userform has been initialize. Though I have fixed this, just want to > know if this is normal. Please see below sample code for example: > > First userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm1" > End Sub > > Second userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm2" > MsgBox Test > If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" > Then > 'Some code' > End If > MsgBox Test > End Sub > > When I run UserForm2 where I have set value of Test to "I am UserForm2", it > shows msgbox "I am UserForm2" however immediately after if.. then statement > value of the variable Test changes and it shows msgbox "I am UserForm1" as > its in UserForm1. Looks like as soon as VBA reads following it changes the > variables: > > And UserForm1.TextBox1 <> "SomeValue" > > Do you have any idea about this? > > _ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > Explore and discover exciting holidays and getaways with Yahoo! India > Travelhttp://in.travel.yahoo.com/ > > Book1.xls > 44KViewDownload Own a website.Get an unlimited package.Pay next to nothing.*Go to http://in.business.yahoo.com/ --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement
Ashish, Thank you for the information. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserForm Initializing after if.. then statement Hi Alokeshwar, This is absolutely normal. 1. When you try to fetch the values from userform1, it is initialized and new value of Test set upon. To avoid this you can use activate event of userform1. Difference between activate and initialize is of Foreground visibility active state and Background invisible initiation state. 2. But the above solution is a mere Jugad technique. Look below to intelligently correct your problem Instead of using If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" Then use this If UserForm1.TextBox1 <> "SomeValue" AND UserForm2.TextBox1 <> "SomeValue" Then and then it'll display same value across both Msgbox in UserForm2. Hope you'll understand the difference. Let me explain with example for all excel users. When we use boolean expression similar to this A OR B OR C. The order of evaluation is C --> B --> A. If C is True, then it don't evaluates A and B and the result of expression becomes true. But When we use boolean expression similar to this A AND B AND C. The order of evaluation is A --> B --> C. If A is False, then it don't evaluates C and B and the result of expression becomes False. If you carefully see the code and run using F8, you'll better understand the above 2 points. Try with different expressions to really learn this. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 3:11 pm, Alokeshwar Tiwary wrote: > Dear All, > > I encountered a very strange problem. I have two userforms and both of them > define values for few variables at Initialize event and also they both refer > to each other to verify certain conditions. Now what's happening is - > immediately after if.. then statement, the variables change .. as if the > other userform has been initialize. Though I have fixed this, just want to > know if this is normal. Please see below sample code for example: > > First userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm1" > End Sub > > Second userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm2" > MsgBox Test > If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" > Then > 'Some code' > End If > MsgBox Test > End Sub > > When I run UserForm2 where I have set value of Test to "I am UserForm2", it > shows msgbox "I am UserForm2" however immediately after if.. then statement > value of the variable Test changes and it shows msgbox "I am UserForm1" as > its in UserForm1. Looks like as soon as VBA reads following it changes the > variables: > > And UserForm1.TextBox1 <> "SomeValue" > > Do you have any idea about this? > > _ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > Explore and discover exciting holidays and getaways with Yahoo! India > Travelhttp://in.travel.yahoo.com/ > > Book1.xls > 44KViewDownload Cricket on your mind? Visit the ultimate cricket website. Enter http://beta.cricket.yahoo.com --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: UserForm Initializing after if.. then statement
Ashish, Thank you for the information. _ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know." From: Ashish Jain <26may.1...@gmail.com> To: MS EXCEL AND VBA MACROS Sent: Sunday, 7 June, 2009 9:31:48 AM Subject: $$Excel-Macros$$ Re: UserForm Initializing after if.. then statement Hi Alokeshwar, This is absolutely normal. 1. When you try to fetch the values from userform1, it is initialized and new value of Test set upon. To avoid this you can use activate event of userform1. Difference between activate and initialize is of Foreground visibility active state and Background invisible initiation state. 2. But the above solution is a mere Jugad technique. Look below to intelligently correct your problem Instead of using If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" Then use this If UserForm1.TextBox1 <> "SomeValue" AND UserForm2.TextBox1 <> "SomeValue" Then and then it'll display same value across both Msgbox in UserForm2. Hope you'll understand the difference. Let me explain with example for all excel users. When we use boolean expression similar to this A OR B OR C. The order of evaluation is C --> B --> A. If C is True, then it don't evaluates A and B and the result of expression becomes true. But When we use boolean expression similar to this A AND B AND C. The order of evaluation is A --> B --> C. If A is False, then it don't evaluates C and B and the result of expression becomes False. If you carefully see the code and run using F8, you'll better understand the above 2 points. Try with different expressions to really learn this. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 3:11 pm, Alokeshwar Tiwary wrote: > Dear All, > > I encountered a very strange problem. I have two userforms and both of them > define values for few variables at Initialize event and also they both refer > to each other to verify certain conditions. Now what's happening is - > immediately after if.. then statement, the variables change .. as if the > other userform has been initialize. Though I have fixed this, just want to > know if this is normal. Please see below sample code for example: > > First userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm1" > End Sub > > Second userform has following code: > > Private Sub UserForm_Initialize() > Test = "I am UserForm2" > MsgBox Test > If UserForm2.TextBox1 <> "SomeValue" And UserForm1.TextBox1 <> "SomeValue" > Then > 'Some code' > End If > MsgBox Test > End Sub > > When I run UserForm2 where I have set value of Test to "I am UserForm2", it > shows msgbox "I am UserForm2" however immediately after if.. then statement > value of the variable Test changes and it shows msgbox "I am UserForm1" as > its in UserForm1. Looks like as soon as VBA reads following it changes the > variables: > > And UserForm1.TextBox1 <> "SomeValue" > > Do you have any idea about this? > > _ > "There are known knowns. These are things we know that we know. There are > known unknowns. That is to say, there are things that we know we don't know. > But there are also unknown unknowns. There are things we don't know we don't > know." > > Explore and discover exciting holidays and getaways with Yahoo! India > Travelhttp://in.travel.yahoo.com/ > > Book1.xls > 44KViewDownload Bollywood news, movie reviews, film trailers and more! Go to http://in.movies.yahoo.com/ --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Material Requirment
Thanks Ashish On Sun, Jun 7, 2009 at 12:33 PM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi Kamlesh, > > Check the files section of this group. > http://groups.google.com/group/excel-macros/files > > - > Regards > Ashish Jain > http://www.excelitems.com > http://www.openexcel.com > *Developer of Open XL* > - > > On Jun 2, 4:08 pm, kamlesh agrawal wrote: > > Hi > > I am new to this group . i want some material for v b programming and > list > > of formulas for excels > > > > Thanks in Advance > > > > -- > > Kamlesh S Agrawal > > "Try hard to get what you likeotherwise you'll be forced to like > > whatever you'll get" > > > -- Kamlesh S Agrawal "Try hard to get what you likeotherwise you'll be forced to like whatever you'll get" --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel macros
Hi Mayank Please refer to the group's files section and online resources. You may search through excelitems.com too. Excel VBA Learning Files --> http://groups.google.com/group/excel-macros/files Website --> http://www.excelitems.com - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 1, 7:15 pm, mayank khare wrote: > Hai, > I want to learn indepth excel macros. > Plz tell the resource to learn this. > I do not know any language ie Visual Basic ,which i know is required to > write a macro. > Plz guide me. > > -- > Warm Regards > Mayank Khare --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Material Requirment
Hi Kamlesh, Check the files section of this group. http://groups.google.com/group/excel-macros/files - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 2, 4:08 pm, kamlesh agrawal wrote: > Hi > I am new to this group . i want some material for v b programming and list > of formulas for excels > > Thanks in Advance > > -- > Kamlesh S Agrawal > "Try hard to get what you likeotherwise you'll be forced to like > whatever you'll get" --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to force a spreadsheet to load from a server and not cache
Hi Dean, This has nothing to do with excel. Either clear your Internet explorer (or of the browser you're using) or permanently set its cache size to 0KB. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 5, 1:46 am, DeanL wrote: > Hi guys, > > I have a web page with links to excel spreadsheets on a server. The > problem I'm having is that when I update the spreadsheet and upload a > new version to the server then the links from the web page cause a > copy cached on the user's local machine to open instead of calling the > new version from the server. > > Is there a way to force excel to call the new copy each time or does > this have to be done through the web page? > > Any help you can offer would be greatly appreciated. > > Many thanks, Dean... --~--~-~--~~~---~--~~ - 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 - -~--~~~~--~~--~--~---
