Hi Prashant, I guess it is not the best practice to have the same identifier name for a variable that going to be used locally and globally.But if you still want have the same situation please use any of the example shared by Lalit Or Paul.
Bu i will avoid this situation as this way of coding will put us in a situation where it will not able for us to differentiate which varable we are using. Regards Prince On Thursday, January 3, 2013 11:15:17 PM UTC+5:30, prashant shinde wrote: > > > > > -------- Original message -------- > Subject: Conflict between Local and Global variable > From: "Shinde, Hanumant" <hanuman...@capgemini.com <javascript:>> > To: "arsfa...@yahoo.co.in <javascript:>" <arsfa...@yahoo.co.in<javascript:> > > > 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.
