3
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

Excel VBAコース第1回内容

Last updated at Posted at 2019-04-08

全12回 Excel VBAコースの第1回の内容です。

#マクロボタンの作成
・ボタン作成の仕方
・メッセージボックス(MsgBox)
#セルの値の取得・入力
・CellsとRange
#四則演算
・+ - × ÷
・割り算の際、整数部分のみ出すのは「¥」、余りのみ出すのは「Mod」

#文字列連結
・文字列を連結する場合は「&」でつなげる

#デバッグ
・エラーが出るとデバッグモード(エラーになっている場所を探すモード)になる
・中断するには上のメニューの「□」を押す

3
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?