[skyhawk133]

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!

[Jayman]

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

[skyhawk133]

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

[Louisda16th]

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 August 2006 - 08:11 AM

[Louisda16th]

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 August 2006 - 08:29 AM

[skyhawk133]

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

[Amadeus]

Great start, Louisda16th!

[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 August 2006 - 06:14 AM

[Louisda16th]

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

[skyhawk133]

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!!

[Louisda16th]

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

[Louisda16th]

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

[Louisda16th]

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 August 2006 - 06:52 PM

[skyhawk133]

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!

[Louisda16th]

skyhawk133, on 15 Aug, 2006 - 09:22 PM, said:

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

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