Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default When DIM statements don't work

Each programming language has its on syntax and conventions. If they were
all the same, there would be no reason to have more than one language.
Conventions are determined by the author of the language.

A better question is why would someone try to use a programming language
without learning the syntax and conventions.

Use of Dim is not required. So if you want the default type, then you don't
need to use it. However, the usual recommendation is to put in Option
Explict at the top of the module. This forces every variable to be declared
with a dim statement. It is useful because if you mispell you variable, the
debugger will flag it as undeclared. Otherwise, you might miss that you
have created a subtle error.

--
Regards,
Tom Ogilvy

wrote in message
...
Many thanks to both Trevor and Pikus for their help. Two
things still bother me:

1. what is the use of a Dim statement if the default type
is what you get anyway?

2. why would the originator of VB not follow the
conventions of other programming languages and allow multi
variables to be typed the same in the same line?




Reply
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
IF statements with * character doesn't work [email protected] Excel Worksheet Functions 5 November 8th 06 03:47 PM
IF Statements (Mutliple Statements) Deezel Excel Worksheet Functions 3 October 19th 06 06:13 AM
Getting multiple IF statements to work Psycho0426 Excel Discussion (Misc queries) 15 August 18th 06 04:31 PM
I'm desperate I posted earlier about "If" statements that don't work but are correct. Now... Marc Excel Worksheet Functions 2 April 5th 06 09:27 PM
Cant get totals to work with IF statements spelingchampeon Excel Worksheet Functions 4 October 9th 05 03:14 PM


All times are GMT +1. The time now is 04:02 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"