Alrighty you VB experts, I need your help putting together the ref sheet for Visual Basic.

It should cover the same type of things the C++ ref sheet covers, and we'll eventually do a more advanced one. Post everything here and we'll start to assemble this bad boy!

Will this be a VB.NET ref sheet or VB6?

Let's go with VB6 as that is what is still taught in most schools I believe...

Datatypes:
Boolean, Byte, Currency, Date, Double, Integer, Long, Single, String, Variant.

Control Structures:

1)
If (<condition>) Then
<statments>
else
<statements>
End If

2)
IIF(<condition>,<truestatements>,<falsestatements>)

Case Control:
Select Case(<expression>)
Case(<expression 1>)
<statements>
Case (<expression 2)
<statements>
.
.
.
Case(<expression n>)
<statements>
Case else
<statements>
End Select

This post has been edited by Louisda16th: 15 Aug, 2006 - 07:11 AM

3) Loops

a)
For (<counter>) = <startvall> To <endval> Step <Increment/Decrement>
(<statements>)
Next (<counter>)

B )
Do While(<expression>)
<statements>
Loop

c)
Do
<statements>
Loop While(<expression>)

d)
Do Until(<expression>)
<statements>
Loop

e)
Do
<statements>
Loop Until(<expression>)

f)
While <expression>
<statements>
Wend


Operators:
Arithmetic:
+,-,*,/,Mod,^
Logical:
AND, NOT, OR XOR,IS,EQV,IMP,LIKE
&-(Concatenation)
Comparision:
=,<,>,<=,>=


Common Events
Activte
Click
Change
DblClick
KeyDown
KeyUp
KeyPress
GotFocus
LostFocus
MouseDown
MouseUp
MouseMove

This post has been edited by Louisda16th: 15 Aug, 2006 - 07:29 AM

What color should the VB sheets be? I was thinking something kinda yellow/orange. no idea why though.

Great start, Louisda16th!

Thanx Amadeus (call me Ashwith). Heres smthin more:
Type declaration characters:
%-Integer
$-String
@-Currency
&-Long
#-Double
!-Single
Variable Declaration:
Dim/Static/Public <VarName> As <DataType>

Defining Constants:
Const <Name> = <Value>

This post has been edited by Louisda16th: 16 Aug, 2006 - 05:14 AM

Arrays:
Declaration(0 Based Indexing)
Dim <varname>(<MaxIndexVal>) As <DataType>

(User Defined Indexing)
Dim <Varname>(<MinIndexVal> To <MaxIndexVal>) As <DataType>

Dynamic Arrays
Dim <varname>() As <DataType>
Redim <varname>(MaxIndexVal>)

For Each Next Loop
This Shud be at the loops section. I 4got bout it:
For Each <element> In <Group>
<statements>
Next <element>

With Statement(Im not sure wat section this cms under)

With <objectname>
.<Property1> =<Value>
.<Property2> =<Value>
.
.
.<Propertyn> =<Value>
End With

Alrighty, I think I can put all of that together, let me get all of the data put in the sheet and I'll post it tomorrow. Thanks a ton!!

Well Im not sure if these can be included as part of a reference sheet but i put em cause they are (dats wat i think) used very often
Common Controls
Label, Textbox, CommandButton, PictureBox, Frame, CheckBox, ScrollBars, Timer, DriveListBox, DirectoryListBox, FileListBox,Shape,Line,Data control,Image,OLE,ADODC

Some Library Functions

String:
LCase, UCase, Len, Trim, LTrim, RTrim, Left, Right, Mid, InStr, Space, String, Str, Asc, Chr, StrReverse

Numeric:
Int, Fix, CInt, Sgn, Val, Rnd, Randomize, Format, Round

Date & Time:
Now, Date, Date$, Time, Time$, DatePart, Day, Month, Year, Hour, Minute, Second, Timer, DateAdd, DateDiff.

Math:
Abs, Atn, Cos, Exp, Log, Sin, Sqr, Tan

Miscellaneous:
Is..., VarType, InputBox, MsgBox

Procedures:

[Private/Public] Sub <name> (<ArgumentList>)
<statements>
End Sub
Calling:
[Call] <name>

Functions:

[Private/Public] <Name>(<ArgumentList>) [As <Type>]

Modules:
Form Module
Standard Module
Class Module

Error Handling

On Error Statement:

On Error Goto <LineNumber>
On Error Goto <Label>
On Error Resume Next

Err Object:
Properties:
Number
Source
Description

Methods:
Clear
Raise

Error Object:
Properties:
Description
Number
Source
SQLState
NativeError

Leaving Error Handlers:
Resume
Resume Next
Exit Sub/Function/Property
End Sub/Function/Property
Err.Raise

(dat kinda wraps up all I know. theres also Database systems which i had to learn in school but it wont fit in)

This post has been edited by Louisda16th: 15 Aug, 2006 - 05:52 PM

We'll be doing an advanced one once I get all the basic ones done... we can fit the more advanced stuff in those Thanks again for all the hard work!

About da colours, i guess its fine if its light. orange looks gud i guess.

I know I'm posting this kinda late...Just hope Chris reads this in time

File Handling:

Open "<filename>" for <mode> as <#handler>

where mode is:
INPUT : For Reading Files
OUTPUT : For Writing/Overwriting a File
APPEND : For Adding Data to a File


and handler is a positive integer. Eg. 1,2,100...etc..

For reading fields from one line of data from a file into variables
INPUT <#handler>, <variable list>

For reading the entire line in the file into a single string
LINE INPUT <#handler>,<string_variable>

For Writing Data enclosed in quotes:
WRITE #1, <variable/constant/expression>

For Writing Data without quotes:
PRINT #1, <variable/constant/expression>

To Close the Data File:
CLOSE <#handler>

Common Functions used:
EOF(<#handler>) : returns 1 if End of File is encountered else returns 0.

LOF(<#handler>) : returns the size of the file in bytes


P.S : I haven't mentioned Binary and Random File Modes (along with R/W Access permissions) because I felt it would fit better in the Advanced VB Reference Sheet.

Born2Code, can you take what you posted, and the things in this thread and combine them in to a document that's 115 lines in length... Just take the important/most used things a beginner to VB would use.

Once you've posted the .txt I'll put it in the pdf. Thanks!!!

Heres my version:

This post has been edited by Louisda16th: 18 Aug, 2006 - 07:11 PM

I'll just do that now.

Ok, I've attached the Text File.
I've taken stuff from Louisda16th's Version,Corrected all the errors(lucky I noticed them) and added some content as well.

The Content looks perfect for a beginner.

Looking forward for the next Reference Sheets.