Excel/VBA/基本 - 変更履歴

Admin: /* 変数を使う */

2023-02-17T18:45:56Z

‎変数を使う

Admin: /* 基本 */

2023-02-17T13:48:13Z

‎基本

Admin: ページの作成:「==基本== マクロのmodule1に以下を記述

 public Function Test dim a as integer dim b as integer dim c as string c = "hello" a = 2 b = 1 Test = c & (a + b)...」

2023-02-17T13:18:56Z

ページの作成:「==基本== マクロのmodule1に以下を記述 <pre> public Function Test dim a as integer dim b as integer dim c as string c = "hello" a = 2 b = 1 Test = c & (a + b)...」

新規ページ

==基本==

マクロのmodule1に以下を記述
<pre>
public Function Test
dim a as integer
dim b as integer
dim c as string
c = "hello"
a = 2
b = 1
Test = c & (a + b)
End Function
</pre>
セルに以下をいれるとhello3が入る
=Test()

@@ 行15: / 行15: @@
 dim a as integer
 dim b as integer
-dim c as string
+dim str as string
-c = "hello"
+str = "hello"
 a = 2
 b = 1
-Test = c & (a + b)
+Test = str & (a + b)
 End Function
 </pre>
 セルに以下をいれるとhello3が入る
   =Test()

@@ 行1: / 行1: @@
-==基本==
+==セルに値を返す==
 マクロのmodule1に以下を記述
 <pre>
 public Function Test