LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default global or local intializing ??

i'm workin' with VBE (visual basic excel).

i've several userforms linked one with the other
in each object of the userforms (command buttons i.e.) i've writed some
lines of code.
i use many local variables as indexes for my cycles.
I HAVE NOT initialized none of them and on my PC everything works right
!

i've send my file to one of my testers and he told me he can't run
macros involved because variables are not initialized.

1st question: how could that be possible ?? maybe different version of
VB &/or EXCEL ??

2nd question: how could i initialize all variables without acting in
EVERY SINGLE button containing a cycle or a local VARIABLE ?

3rd question: is it possible to declare all variables involved once in
a time? (i.e. launchin a macro that declare all variables kind makin
them acting as GLOBAL VARIABLES)

really thanks 4 answering!

 
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
How can I change a Name scope from local to Global? Henry Excel Discussion (Misc queries) 7 April 9th 10 10:36 PM
How can I change a Name scope from local to Global? Henry Excel Discussion (Misc queries) 0 September 23rd 08 07:24 PM
Global name used in local version clara Excel Discussion (Misc queries) 3 June 16th 08 06:54 PM
User Defined Functions - local or global? Simon Excel Worksheet Functions 5 September 27th 06 09:15 AM
Global vs Local variables Ken Loomis Excel Programming 1 October 12th 04 05:03 AM


All times are GMT +1. The time now is 12:32 AM.

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"