-------- Original message -------- Subject: Conflict between Local and Global variable From: "Shinde, Hanumant" <hanumant.shi...@capgemini.com> To: "arsfan2...@yahoo.co.in" <arsfan2...@yahoo.co.in> CC:
Hi friends I have below query. There is variable xyz which has global scope as well as local scope. In below sub I am able to change the value of local xyz. How can I change the value of public xyz. ‘Global variable xyz Public xyz As Integer Sub test(abc As Integer) ‘Local variable xyz Dim xyz As Integer xyz = abc + 10 Debug.Print xyz 'xyz = 20 this will be output End Sub Sub calling() xyz = 10 Call test(xyz) Debug.Print xyz 'xyz = 10 this will be output End Sub This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
