Top > Excel VBA ¤Ç¥Ç¥¶¥¤¥ó¥Ñ¥¿¡¼¥ó > Adapter¥Ñ¥¿¡¼¥ó¡Ê·Ñ¾µ¡Ë
·Ñ¾µ¤ò»È¤Ã¤¿Adapter¥Ñ¥¿¡¼¥ó¤Î¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à¤òExcelVBA¤Çµ½Ò¤¹¤ë¤È
°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£¥â¥¸¥å¡¼¥ë¤´¤È¤Ë¥×¥í¥°¥é¥à¤ò¼¨¤·¤Þ¤¹¡£
Top > Excel VBA ¤Ç¥Ç¥¶¥¤¥ó¥Ñ¥¿¡¼¥ó > Adapter¥Ñ¥¿¡¼¥ó¡Ê·Ñ¾µ¡Ë
·Ñ¾µ¤ò»È¤Ã¤¿Adapter¥Ñ¥¿¡¼¥ó¤Î¥µ¥ó¥×¥ë¥×¥í¥°¥é¥à¤òExcelVBA¤Çµ½Ò¤¹¤ë¤È
°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£¥â¥¸¥å¡¼¥ë¤´¤È¤Ë¥×¥í¥°¥é¥à¤ò¼¨¤·¤Þ¤¹¡£
'=================================================>>>>>>>>>>
'ɸ½à¥â¥¸¥å¡¼¥ë¡§modCBanner
'===========================================================
'VBA ¤Î¥¯¥é¥¹¤Ë¤Ï¥³¥ó¥¹¥È¥é¥¯¥¿¤òÄêµÁ¤Ç¤¤Ê¤¤¤Î¤Ç
'ɸ½à¥â¥¸¥å¡¼¥ë¤ËÄêµÁ¤µ¤ì¤¿¥×¥í¥·¡¼¥¸¥ã¤òÊѤï¤ê¤Ë»È¤¦¡£
Option Explicit
'*** ¥³¥ó¥¹¥È¥é¥¯¥¿£² ***
Public Function Init2(pstrValue As String) As clsCBanner
Dim obj As clsCBanner
Set obj = New clsCBanner
'¥³¥ó¥¹¥È¥é¥¯¥¿¤Î¸Æ¤Ó½Ð¤·
Call obj.Init2(pstrValue)
Set Init2 = obj
End Function
'<<<<<<<<<<=================================================
'=================================================>>>>>>>>>>
'¥¯¥é¥¹¥â¥¸¥å¡¼¥ë¡§clsCBanner
'===========================================================
Option Explicit
'¥×¥í¥Ñ¥Æ¥£¾ðÊó
Private mstrValue As String
'ɸ½à¥â¥¸¥å¡¼¥ë¤ËÄêµÁ¤µ¤ì¤¿¥³¥ó¥¹¥È¥é¥¯¥¿¤«¤é
'¸Æ¤Ó½Ð¤µ¤ì¤ë¥á¥½¥Ã¥ÉŽ¡
Public Sub Init2(pstrValue As String)
mstrValue = pstrValue
End Sub
Public Sub ShowWithParen()
Debug.Print ("(" & mstrValue & ")")
End Sub
Public Sub ShowWithAster()
Debug.Print ("*" & mstrValue & "*")
End Sub
'<<<<<<<<<<=================================================
'=================================================>>>>>>>>>>
'¥¯¥é¥¹¥â¥¸¥å¡¼¥ë¡§clsIPrint
'===========================================================
Option Explicit
Public Sub PrintWeak()
'VBA ¤Î IDE ¤Ï¼ÂÂΤÎ̵¤¤¥×¥í¥·¡¼¥¸¥ã¤ò
'¼«Æ°Åª¤Ëºï½ü¤·¤Æ¤·¤Þ¤¦¤Î¤Ç
'¥³¥á¥ó¥È¹Ô¤ò½ñ¤¤¤Æ¤ª¤¯
End Sub
Public Sub PrintStrong()
'VBA ¤Î IDE ¤Ï¼ÂÂΤÎ̵¤¤¥×¥í¥·¡¼¥¸¥ã¤ò
'¼«Æ°Åª¤Ëºï½ü¤·¤Æ¤·¤Þ¤¦¤Î¤Ç
'¥³¥á¥ó¥È¹Ô¤ò½ñ¤¤¤Æ¤ª¤¯
End Sub
'<<<<<<<<<<=================================================
'=================================================>>>>>>>>>>
'ɸ½à¥â¥¸¥å¡¼¥ë¡§modCPrintBanner
'===========================================================
'VBA ¤Î¥¯¥é¥¹¤Ë¤Ï¥³¥ó¥¹¥È¥é¥¯¥¿¤òÄêµÁ¤Ç¤¤Ê¤¤¤Î¤Ç
'ɸ½à¥â¥¸¥å¡¼¥ë¤ËÄêµÁ¤µ¤ì¤¿¥×¥í¥·¡¼¥¸¥ã¤òÊѤï¤ê¤Ë»È¤¦¡£
Option Explicit
'*** ¥³¥ó¥¹¥È¥é¥¯¥¿£² ***
Public Function Init2(pstrValue As String _
) As clsCPrintBanner
Dim obj As clsCPrintBanner
Set obj = New clsCPrintBanner
'¥³¥ó¥¹¥È¥é¥¯¥¿¤Î¸Æ¤Ó½Ð¤·
Call obj.Init2(pstrValue)
Set Init2 = obj
End Function
'<<<<<<<<<<=================================================
'=================================================>>>>>>>>>>
'¥¯¥é¥¹¥â¥¸¥å¡¼¥ë¡§clsCPrintBanner
'===========================================================
Option Explicit
'¥¹¡¼¥Ñ¥¯¥é¥¹¤Î¾ðÊó
'¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤Î·Ñ¾µ¤È°Ñ¾ù¤Ç
'¼ÂÁõ¤ò·Ñ¾µ¤·¤Æ¤¤¤ë¤è¤¦¤Ë¸«¤»¤«¤±¤ë¡£
Implements clsCBanner
Private mobjSuper As clsCBanner
'¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹¤Î·Ñ¾µ
Implements clsIPrint
'ɸ½à¥â¥¸¥å¡¼¥ë¤ËÄêµÁ¤µ¤ì¤¿¥³¥ó¥¹¥È¥é¥¯¥¿¤«¤é
'¸Æ¤Ó½Ð¤µ¤ì¤ë¥á¥½¥Ã¥É¡£
Public Sub Init2(pstrValue As String)
'¥¹¡¼¥Ñ¡¼¥¯¥é¥¹¤Î¥³¥ó¥¹¥È¥é¥¯¥¿¤Î¼Â¹Ô
Set mobjSuper = modCBanner.Init2(pstrValue)
End Sub
'clsCBanner¤ò·Ñ¾µ¤·¤Æ¤¤¤ë¤è¤¦¤Ë¤ß¤»¤«¤±¤ë¡£
Public Sub ShowWithParen()
Call mobjSuper.ShowWithParen
End Sub
'clsCBanner¤ò·Ñ¾µ¤·¤Æ¤¤¤ë¤è¤¦¤Ë¤ß¤»¤«¤±¤ë¡£
Public Sub ShowWithAster()
Call mobjSuper.ShowWithAster
End Sub
'clsIPrint¤ò¼ÂÁõ¤·¤Æ¤¤¤ë¤è¤¦¤Ë¤ß¤»¤«¤±¤ë¡£
Public Sub PrintStrong()
Call mobjSuper.ShowWithAster
End Sub
'clsIPrint¤ò¼ÂÁõ¤·¤Æ¤¤¤ë¤è¤¦¤Ë¤ß¤»¤«¤±¤ë¡£
Public Sub PrintWeak()
Call mobjSuper.ShowWithParen
End Sub
'-----------------------------------------------------------
'clsIPrint ¤Î¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹
'-----------------------------------------------------------
Private Sub clsIPrint_PrintStrong()
Call Me.PrintStrong
End Sub
Private Sub clsIPrint_PrintWeak()
Call Me.PrintWeak
End Sub
'-----------------------------------------------------------
'clsCBanner ¤Î¥¤¥ó¥¿¡¼¥Õ¥§¥¤¥¹
'-----------------------------------------------------------
Private Sub clsCBanner_init2(pstrValue As String)
'²¿¤â¤·¤Ê¤¤
End Sub
Private Sub clsCBanner_ShowWithParen()
Call Me.ShowWithParen
End Sub
Private Sub clsCBanner_ShowWithAster()
Call Me.ShowWithAster
End Sub
'<<<<<<<<<<=================================================
'=================================================>>>>>>>>>>
'ɸ½à¥â¥¸¥å¡¼¥ë¡§modCMain
'===========================================================
Option Explicit
'*** ¥á¥¤¥ó½èÍý ***
'VBA ¤Î¥¯¥é¥¹¤Ë¤Ï¥¯¥é¥¹¥á¥½¥Ã¥É¤òÄêµÁ¤Ç¤¤Ê¤¤¤Î¤Ç
'ɸ½à¥â¥¸¥å¡¼¥ë¤ËÄêµÁ¤µ¤ì¤¿¥×¥í¥·¡¼¥¸¥ã¤òÊѤï¤ê¤Ë»È¤¦¡£
Sub Main1()
Dim objP As clsIPrint
Set objP = modCPrintBanner.Init2("Hello")
Call objP.PrintWeak
Call objP.PrintStrong
End Sub
'<<<<<<<<<<=================================================
Top > Excel VBA ¤Ç¥Ç¥¶¥¤¥ó¥Ñ¥¿¡¼¥ó > Adapter¥Ñ¥¿¡¼¥ó¡Ê·Ñ¾µ¡Ë
- ¥«¥Æ¥´¥ê¡§
- ¥Ñ¥½¥³¥ó
- ¥×¥í¥°¥é¥ß¥ó¥°
¤³¤Î¥Ú¡¼¥¸¤Ø¤Î¥³¥á¥ó¥È
6aj8Ac Very neat article.Much thanks again. Much obliged.
9XTZvJ Very informative article. Great.
VBADP02_01 - VBA �� Java �Υ��֥������Ȼظ��ץ����ߥ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール レディース コート http://www.pslcbi.com/moncler2014.html
VBADP02_01 - VBA �� Java �Υ��֥������Ȼظ��ץ����ߥ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� モンクレール サイズ4 http://www.pslcbi.com/moncler2014.html
VBADP02_01 - VBA �� Java �Υ��֥������Ȼظ��ץ����ߥ� - Seesaa Wiki�ʥ������� for ���ޡ��ȥե��� moncler モンクレール http://www.pslcbi.com/moncler2014.html