VB6

link

Excel VBA

Visual Basic 6.0

思えばVBの本いっぱい買ったなぁ。この本が最良。

文法

• Quick Reference

配列

  Dim text(0 to 5) as String  'index 0 - 5 の配列

制御構文

If..Then..Else

If A>5 Then Print "A is a bit number!"

For...Next - Loops

For i = 1 to 5
    print #1, i
next i

For Each ... Next

For Each X in Form1.controls
Next X

While...Wend

While i < 5
  i = i +1
Wend

Select Case

Select case i
Case 1 : print "it was a 1"
Case 2 : print "it was a 2"
End select

Do...Loop

Do while i < 5
  i = i + 1
Loop

Choose

Choose (index, "answer1", "answer2", "answer3")

With

With textbox1
  .Height = 100
  .Width = 500
End With

End

End

Stop

Stop

TIPS

• VB ファイルを読む
• Perl VBのプロパティプロシージャを生成
• VB 有効期間に含まれるデータを判定

Excel VBA

• Excel VBA