LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default VBA-Error Message Assistance Needed

The declaration is valid and the scope expands outwards from the procedure to
the module to the project. That being said it is generaly poor coding
practice to use the same name for a global and a local variable.
--
HTH...

Jim Thomlinson


"Zone" wrote:

Dave is right and I am wrong. A local and global variable with the
same name will not cause the problem. But two procedures with the same
name will cause the problem.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message needed if incorrect Date Of Birth (DOB) entered Craig Excel Worksheet Functions 5 January 27th 10 08:24 PM
#VALUE! error message help needed please Bob Newman Excel Worksheet Functions 3 November 25th 07 04:56 PM
VBA Assistance Needed RalphB Excel Discussion (Misc queries) 5 February 22nd 06 06:16 PM
.dll error message help needed Wylie C Excel Programming 0 November 1st 05 04:46 PM
Code assistance needed HJ Excel Programming 7 May 27th 05 04:14 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"