Top > VBA ¤Î¥ª¥Ö¥¸¥§¥¯¥È»Ø¸þ¥×¥í¥°¥é¥ß¥ó¥° > ÆþÌçÊÔ
Â裴²ó¡¡Â裵²ó¡¡Â裶²ó
Â裴²ó¡¡Â裵²ó¡¡Â裶²ó
Top > VBA ¤Î¥ª¥Ö¥¸¥§¥¯¥È»Ø¸þ¥×¥í¥°¥é¥ß¥ó¥° > ÆþÌçÊÔ
Â裴²ó¡¡Â裵²ó¡¡Â裶²ó
¥µ¥ó¥×¥ë¥×¥ë¥°¥é¥à¤Î¥Ç¡¼¥¿¤Î¸«Ä¾¤·¤ò¤«¤±¤Æ¤ß¤Þ¤·¤ç¤¦¡£
¹ç·×¤äÊ¿¶Ñ¤òµá¤á¤ë¤È¤¤Ë»È¤¦¥Ç¡¼¥¿¤ÎÁȤ߹ç¤ï¤»¤Ï¥æ¡¼¥¶¡¼ÄêµÁ·¿¤ò»È
¤¦¤È¤ï¤«¤ê¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
Ʊ¤¸¼ê³¤¤òÊ£¿ôƱ»þ¤Ë¼Â¹Ô¤¹¤ë¤È¤¤Ë»È¤¦¥Ç¡¼¥¿¤ÏÇÛÎó¤ò»È¤¦¤È¶èÊ̤·
¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
¤½¤³¤Ç¡¢Á°²ó¤Î¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à¤ò¥æ¡¼¥¶¡¼ÄêµÁ·¿¤ÎÇÛÎó¤ò»È¤Ã¤Æ½ñ¤
ľ¤¹¤È°Ê²¼¤Î¤è¤¦¤Ê¥×¥í¥°¥é¥à¤Ë¤Ê¤ê¤Þ¤¹¡£
¹ç·×¤äÊ¿¶Ñ¤òµá¤á¤ë¤È¤¤Ë»È¤¦¥Ç¡¼¥¿¤ÎÁȤ߹ç¤ï¤»¤Ï¥æ¡¼¥¶¡¼ÄêµÁ·¿¤ò»È
¤¦¤È¤ï¤«¤ê¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
Ʊ¤¸¼ê³¤¤òÊ£¿ôƱ»þ¤Ë¼Â¹Ô¤¹¤ë¤È¤¤Ë»È¤¦¥Ç¡¼¥¿¤ÏÇÛÎó¤ò»È¤¦¤È¶èÊ̤·
¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
¤½¤³¤Ç¡¢Á°²ó¤Î¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à¤ò¥æ¡¼¥¶¡¼ÄêµÁ·¿¤ÎÇÛÎó¤ò»È¤Ã¤Æ½ñ¤
ľ¤¹¤È°Ê²¼¤Î¤è¤¦¤Ê¥×¥í¥°¥é¥à¤Ë¤Ê¤ê¤Þ¤¹¡£
Option Explicit
<font color="green">'¥æ¡¼¥¶¡¼ÄêµÁ·¿</font>
Private Type typSumAvg
<font color="green"> '¹ç·×</font>
mlngSum As Long
<font color="green"> '¥Ç¡¼¥¿¿ô</font>
mlngNums As Long
<font color="green"> 'Ê¿¶Ñ</font>
mlngAvg As Long
End Type
<font color="green">'¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à£°£³</font>
Sub calc3()
<font color="green"> '¥æ¡¼¥¶¡¼ÄêµÁ·¿¤ÎÇÛÎó</font>
Dim audtSumAvg(2) As typSumAvg
<font color="green"> '¹ç·×¤È¥Ç¡¼¥¿¿ô¤Î½é´ü²½(1)</font>
audtSumAvg(0).mlngSum = 0
audtSumAvg(0).mlngNums = 0
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(1)</font>
audtSumAvg(0).mlngSum = audtSumAvg(0).mlngSum + 10
audtSumAvg(0).mlngNums = audtSumAvg(0).mlngNums + 1
<font color="green"> '¹ç·×¤È¥Ç¡¼¥¿¿ô¤Î½é´ü²½(2)</font>
audtSumAvg(1).mlngSum = 0
audtSumAvg(1).mlngNums = 0
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(2)</font>
audtSumAvg(1).mlngSum = audtSumAvg(1).mlngSum + 100
audtSumAvg(1).mlngNums = audtSumAvg(1).mlngNums + 1
<font color="green"> '¹ç·×¤È¥Ç¡¼¥¿¿ô¤Î½é´ü²½(3)</font>
audtSumAvg(2).mlngSum = 0
audtSumAvg(2).mlngNums = 0
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(3)</font>
audtSumAvg(2).mlngSum = audtSumAvg(2).mlngSum + 1000
audtSumAvg(2).mlngNums = audtSumAvg(2).mlngNums + 1
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(1)</font>
audtSumAvg(0).mlngSum = audtSumAvg(0).mlngSum + 20
audtSumAvg(0).mlngNums = audtSumAvg(0).mlngNums + 1
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¸Ä¿ô¤Î·×»»(2)</font>
audtSumAvg(1).mlngSum = audtSumAvg(1).mlngSum + 200
audtSumAvg(1).mlngNums = audtSumAvg(1).mlngNums + 1
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¸Ä¿ô¤Î·×»»(3)</font>
audtSumAvg(2).mlngSum = audtSumAvg(2).mlngSum + 2000
audtSumAvg(2).mlngNums = audtSumAvg(2).mlngNums + 1
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(1)</font>
audtSumAvg(0).mlngSum = audtSumAvg(0).mlngSum + 30
audtSumAvg(0).mlngNums = audtSumAvg(0).mlngNums + 1
<font color="green"> 'Ê¿¶Ñ¤Î·×»»(1)</font>
audtSumAvg(0).mlngAvg = _
audtSumAvg(0).mlngSum / audtSumAvg(0).mlngNums
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(2)</font>
audtSumAvg(1).mlngSum = audtSumAvg(1).mlngSum + 300
audtSumAvg(1).mlngNums = audtSumAvg(1).mlngNums + 1
<font color="green"> 'Ê¿¶Ñ¤Î·×»»(2)</font>
audtSumAvg(1).mlngAvg = _
audtSumAvg(1).mlngSum / audtSumAvg(1).mlngNums
<font color="green"> '¥Ç¡¼¥¿¤ÎÄɲäȥǡ¼¥¿¿ô¤Î·×»»(3)</font>
audtSumAvg(2).mlngSum = audtSumAvg(2).mlngSum + 3000
audtSumAvg(2).mlngNums = audtSumAvg(2).mlngNums + 1
<font color="green"> 'Ê¿¶Ñ¤Î·×»»(3)</font>
audtSumAvg(2).mlngAvg = _
audtSumAvg(2).mlngSum / audtSumAvg(2).mlngNums
<font color="green"> '·ë²Ì¤Î½ÐÎÏ</font>
Debug.Print "1:Sum=" & CStr(audtSumAvg(0).mlngSum) & _
":Avg=" & CStr(audtSumAvg(0).mlngAvg)
Debug.Print "2:Sum=" & CStr(audtSumAvg(1).mlngSum) & _
":Avg=" & CStr(audtSumAvg(1).mlngAvg)
Debug.Print "3:Sum=" & CStr(audtSumAvg(2).mlngSum) & _
":Avg=" & CStr(audtSumAvg(2).mlngAvg)
End Sub
Â裴²ó¡¡Â裵²ó¡¡Â裶²ó
Top > VBA ¤Î¥ª¥Ö¥¸¥§¥¯¥È»Ø¸þ¥×¥í¥°¥é¥ß¥ó¥° > ÆþÌçÊÔ
- ¥«¥Æ¥´¥ê¡§
- ¥Ñ¥½¥³¥ó
- ¥×¥í¥°¥é¥ß¥ó¥°
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
iD94qW I think this is a real great blog article.Thanks Again. Awesome.
VBAOBJECT0105 - VBA �� Java �Υ��֥������Ȼظ��ץ����ߥ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール ダウン http://www.pslcbi.com/moncler2014.html